{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Points","Award Data Sheet","Award Dropdown","Sectors","Lookup","Start","Award","Certificate","Diploma","Dip Data Sheet","Dip Dropdown","Cert Data Sheet","Cert Dropdown"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":66,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Points","index":0,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Award Overall Grade",null,null,"Certificate Overall Grade",null,null,"Diploma Overall Grade",null,null,"GLH to be awarded"]
[null,"30 GLH","40 GLH",null,"Award Points","Award Grade",null,"Cert Points","Cert Grade",null,"Dip Points","Dip Grade",null,"Award",110]
["U",0,0,null,0,"U",null,0,"U",null,0,"U",null,"Cert",140]
["P",6,8,null,22,"P",null,36,"P",null,72,"PP",null,"Dip",280]
["M",12,16,null,38,"M",null,60,"M",null,96,"MP"]
["D",18,24,null,58,"D",null,96,"D",null,120,"MM"]
[null,null,null,null,null,null,null,null,null,null,158,"DM"]
[null,null,null,null,null,null,null,null,null,null,196,"DD"]

{"sheet":"Award Data Sheet","index":1,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Core units A",null,null,null,null,null,null,"Optional Units"]
["Sector","Unit number","Unit Name","GLH",null,null,null,"Sector","Unit Number","Unit Name","GLH"]
["Vocational Studies","A2","Developing a Personal Progression Plan",30,null,"Vocational Studies","Creating an Art Image","Art and Design","AD5","Creating an Art Image",40]
[null,null,null,null,null,"Vocational Studies","Designing a Product","Art and Design","AD8","Designing a Product",40]
[null,null,null,null,null,"Vocational Studies","Creating a Mood Board","Art and Design","AD10","Creating a Mood Board",40]
[null,null,null,null,null,"Vocational Studies","Creating Prints","Art and Design","AD12","Creating Prints",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out a Scientific Experiment","Applied Science","ASc6","Carrying Out a Scientific Experiment",40]
[null,null,null,null,null,"Vocational Studies","Practical Actions to Protect the Environment","Applied Science","ASc9","Practical Actions to Protect the Environment",40]
[null,null,null,null,null,"Vocational Studies","Making a Chemical Product","Applied Science","ASc10","Making a Chemical Product",40]
[null,null,null,null,null,"Vocational Studies","Investigating Crime Scene Evidence","Applied Science","ASc12","Investigating Crime Scene Evidence",40]
[null,null,null,null,null,"Vocational Studies","Organising a Meeting","Business","B6","Organising a Meeting",40]
[null,null,null,null,null,"Vocational Studies","Branding a Product","Business","B7","Branding a Product",40]
[null,null,null,null,null,"Vocational Studies","Presenting a Business Idea","Business","B9","Presenting a Business Idea",40]
[null,null,null,null,null,"Vocational Studies","Contribute to Running an Event","Business","B10","Contribute to Running an Event",40]
[null,null,null,null,null,"Vocational Studies","Recording Income and Expenditure","Business","B11","Recording Income and Expenditure",40]
[null,null,null,null,null,"Vocational Studies","Communicating with Customers","Business","B12","Communicating with Customers",40]
[null,null,null,null,null,"Vocational Studies","Providing an Activity to Support Children’s Emotional and Social Needs","Caring for Children","CfC5","Providing an Activity to Support Children’s Emotional and Social Needs",40]
[null,null,null,null,null,"Vocational Studies","Planning a Safe Childcare Environment","Caring for Children","CfC6","Planning a Safe Childcare Environment",40]
[null,null,null,null,null,"Vocational Studies","Providing a Children’s Creative Activity","Caring for Children","CfC10","Providing a Children’s Creative Activity",40]
[null,null,null,null,null,"Vocational Studies","Supporting Children’s Learning Through Everyday Experiences","Caring for Children","CfC12","Supporting Children’s Learning Through Everyday Experiences",40]
[null,null,null,null,null,"Vocational Studies","Drawing a Plan of a Room","Construction","CON5","Drawing a Plan of a Room",40]
[null,null,null,null,null,"Vocational Studies","Building a Simple Wall","Construction","CON6","Building a Simple Wall",40]
[null,null,null,null,null,"Vocational Studies","Making Carpentry Joints","Construction","CON7","Making Carpentry Joints",40]
[null,null,null,null,null,"Vocational Studies","Fixing a Water Pipe","Construction","CON8","Fixing a Water Pipe",40]
[null,null,null,null,null,"Vocational Studies","Making an Electrical Circuit","Construction","CON12","Making an Electrical Circuit",40]
[null,null,null,null,null,"Vocational Studies","Creating a Storyboard","Digital Media","DM5","Creating a Storyboard",40]
[null,null,null,null,null,"Vocational Studies","Designing an Interactive Presentation","Digital Media","DM6","Designing an Interactive Presentation",40]
[null,null,null,null,null,"Vocational Studies","Creating an Animation","Digital Media","DM9","Creating an Animation",40]
[null,null,null,null,null,"Vocational Studies","Shooting a Short Film","Digital Media","DM10","Shooting a Short Film",40]
[null,null,null,null,null,"Vocational Studies","Manufacturing an Engineered Product Using Hand Tools","Engineering","ENG5","Manufacturing an Engineered Product Using Hand Tools",40]
[null,null,null,null,null,"Vocational Studies","Carrying out Electrical Installation","Engineering","ENG10","Carrying out Electrical Installation",40]
[null,null,null,null,null,"Vocational Studies","Producing Engineering Drawings using CAD","Engineering","ENG11","Producing Engineering Drawings using CAD",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out Routine Service Tasks on a Motor Vehicle","Engineering","ENG12","Carrying Out Routine Service Tasks on a Motor Vehicle",40]
[null,null,null,null,null,"Vocational Studies","Communication Skills for Health and Social Care","Health and Social Care","HSC6","Communication Skills for Health and Social Care",40]
[null,null,null,null,null,"Vocational Studies","Making Healthy Snacks When Caring for People","Health and Social Care","HSC7","Making Healthy Snacks When Caring for People",40]
[null,null,null,null,null,"Vocational Studies","Advising Others About Healthy Lifestyles","Health and Social Care","HSC8","Advising Others About Healthy Lifestyles",40]
[null,null,null,null,null,"Vocational Studies","Measuring Older Adults’ Fitness Levels for Everyday Tasks","Health and Social Care","HSC11","Measuring Older Adults’ Fitness Levels for Everyday Tasks",40]
[null,null,null,null,null,"Vocational Studies","Preparing and Cooking Food","Hospitality","HT5","Preparing and Cooking Food",40]
[null,null,null,null,null,"Vocational Studies","Serving Food and Drink","Hospitality","HT6","Serving Food and Drink",40]
[null,null,null,null,null,"Vocational Studies","Exploring Local Visitor Attractions","Hospitality","HT7","Exploring Local Visitor Attractions",40]
[null,null,null,null,null,"Vocational Studies","Exploring Travel and Tourism in the UK","Hospitality","HT8","Exploring Travel and Tourism in the UK",40]
[null,null,null,null,null,"Vocational Studies","Delivering Customer Service in Hospitality and Tourism","Hospitality","HT10","Delivering Customer Service in Hospitality and Tourism",40]
[null,null,null,null,null,"Vocational Studies","Developing Digital Information Using IT","IT","IT5","Developing Digital Information Using IT",40]
[null,null,null,null,null,"Vocational Studies","Using Digital Communication Technologies","IT","IT6","Using Digital Communication Technologies",40]
[null,null,null,null,null,"Vocational Studies","Creating a Spreadsheet to Solve Problems","IT","IT8","Creating a Spreadsheet to Solve Problems",40]
[null,null,null,null,null,"Vocational Studies","Creating a Website","IT","IT9","Creating a Website",40]
[null,null,null,null,null,"Vocational Studies","Caring for and Feeding Animals","Land-based Studies","LBS6","Caring for and Feeding Animals",40]
[null,null,null,null,null,"Vocational Studies","Moving and Accommodating Animals","Land-based Studies","LBS7","Moving and Accommodating Animals",40]
[null,null,null,null,null,"Vocational Studies","Growing Plants","Land-based Studies","LBS8","Growing Plants",40]
[null,null,null,null,null,"Vocational Studies","Preparing Soil for Planting","Land-based Studies","LBS12","Preparing Soil for Planting",40]
[null,null,null,null,null,"Vocational Studies","Using a Stimulus for Performance","Performing Arts","PA5","Using a Stimulus for Performance",40]
[null,null,null,null,null,"Vocational Studies","Performing a Dance Routine","Performing Arts","PA8","Performing a Dance Routine",40]
[null,null,null,null,null,"Vocational Studies","Performing a Piece of Music","Performing Arts","PA9","Performing a Piece of Music",40]
[null,null,null,null,null,"Vocational Studies","Acting in a Performance","Performing Arts","PA10","Acting in a Performance",40]
[null,null,null,null,null,"Vocational Studies","Rehearsing for a Performance","Performing Arts","PA12","Rehearsing for a Performance",40]
[null,null,null,null,null,"Vocational Studies","Taking Part in Fitness Testing","Public Services","PS6","Taking Part in Fitness Testing",40]
[null,null,null,null,null,"Vocational Studies","Responding to an Incident","Public Services","PS8","Responding to an Incident",40]
[null,null,null,null,null,"Vocational Studies","Planning and Navigating a Route","Public Services","PS9","Planning and Navigating a Route",40]
[null,null,null,null,null,"Vocational Studies","Contributing to your Community","Public Services","PS11","Contributing to your Community",40]
[null,null,null,null,null,"Vocational Studies","Playing Sport","Sport","SP7","Playing Sport",40]
[null,null,null,null,null,"Vocational Studies","Assisting in a Sports Activity","Sport","SP9","Assisting in a Sports Activity",40]
[null,null,null,null,null,"Vocational Studies","Getting People Active","Sport","SP11","Getting People Active",40]
[null,null,null,null,null,"Vocational Studies","Keeping Active and Healthy","Sport","SP12","Keeping Active and Healthy",40]

{"sheet":"Award Dropdown","index":2,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Vocational Studies Group A"]
["Art and Design","Creating an Art Image",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B2)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A2)>=1,\"\",ROW()))","v":2},{"$f":"IF(ROW(B2)-ROW(B$2)+1>COUNT(C$2:C$70),\"\",INDEX(B:B,SMALL(C$2:C$70,1+ROW(B2)-ROW(B$2))))","v":"Creating an Art Image"}]
["Art and Design","Designing a Product",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B3)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A3)>=1,\"\",ROW()))","v":3},{"$f":"IF(ROW(B3)-ROW(B$2)+1>COUNT(C$2:C$70),\"\",INDEX(B:B,SMALL(C$2:C$70,1+ROW(B3)-ROW(B$2))))","v":"Designing a Product"}]
["Art and Design","Creating a Mood Board",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B4)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A4)>=1,\"\",ROW()))","v":4},"Creating a Mood Board"]
["Art and Design","Creating Prints",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B5)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A5)>=1,\"\",ROW()))","v":5},"Creating Prints"]
["Applied Science","Carrying Out a Scientific Experiment",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B6)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A6)>=1,\"\",ROW()))","v":6},"Carrying Out a Scientific Experiment"]
["Applied Science","Practical Actions to Protect the Environment",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B7)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A7)>=1,\"\",ROW()))","v":7},"Practical Actions to Protect the Environment"]
["Applied Science","Making a Chemical Product",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B8)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A8)>=1,\"\",ROW()))","v":8},"Making a Chemical Product"]
["Applied Science","Investigating Crime Scene Evidence",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B9)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A9)>=1,\"\",ROW()))","v":9},"Investigating Crime Scene Evidence"]
["Business","Organising a Meeting",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B10)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A10)>=1,\"\",ROW()))","v":10},"Organising a Meeting"]
["Business","Branding a Product",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B11)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A11)>=1,\"\",ROW()))","v":11},"Branding a Product"]
["Business","Presenting a Business Idea",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B12)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A12)>=1,\"\",ROW()))","v":12},"Presenting a Business Idea"]
["Business","Contribute to Running an Event",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B13)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A13)>=1,\"\",ROW()))","v":13},"Contribute to Running an Event"]
["Business","Recording Income and Expenditure",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B14)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A14)>=1,\"\",ROW()))","v":14},"Recording Income and Expenditure"]
["Business","Communicating with Customers",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B15)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A15)>=1,\"\",ROW()))","v":15},"Communicating with Customers"]
["Caring for Children","Providing an Activity to Support Children’s Emotional and Social Needs",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B16)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A16)>=1,\"\",ROW()))","v":16},"Providing an Activity to Support Children’s Emotional and Social Needs"]
["Caring for Children","Planning a Safe Childcare Environment",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B17)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A17)>=1,\"\",ROW()))","v":17},"Planning a Safe Childcare Environment"]
["Caring for Children","Providing a Children’s Creative Activity",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B18)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A18)>=1,\"\",ROW()))","v":18},"Providing a Children’s Creative Activity"]
["Caring for Children","Supporting Children’s Learning Through Everyday Experiences",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B19)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A19)>=1,\"\",ROW()))","v":19},"Supporting Children’s Learning Through Everyday Experiences"]
["Construction","Drawing a Plan of a Room",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B20)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A20)>=1,\"\",ROW()))","v":20},"Drawing a Plan of a Room"]
["Construction","Building a Simple Wall",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B21)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A21)>=1,\"\",ROW()))","v":21},"Building a Simple Wall"]
["Construction","Making Carpentry Joints",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B22)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A22)>=1,\"\",ROW()))","v":22},"Making Carpentry Joints"]
["Construction","Fixing a Water Pipe",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B23)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A23)>=1,\"\",ROW()))","v":23},"Fixing a Water Pipe"]
["Construction","Making an Electrical Circuit",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B24)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A24)>=1,\"\",ROW()))","v":24},"Making an Electrical Circuit"]
["Digital Media","Creating a Storyboard",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B25)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A25)>=1,\"\",ROW()))","v":25},"Creating a Storyboard"]
["Digital Media","Designing an Interactive Presentation",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B26)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A26)>=1,\"\",ROW()))","v":26},"Designing an Interactive Presentation"]
["Digital Media","Creating an Animation",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B27)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A27)>=1,\"\",ROW()))","v":27},"Creating an Animation"]
["Digital Media","Shooting a Short Film",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B28)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A28)>=1,\"\",ROW()))","v":28},"Shooting a Short Film"]
["Engineering","Manufacturing an Engineered Product Using Hand Tools",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B29)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A29)>=1,\"\",ROW()))","v":29},"Manufacturing an Engineered Product Using Hand Tools"]
["Engineering","Carrying out Electrical Installation",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B30)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A30)>=1,\"\",ROW()))","v":30},"Carrying out Electrical Installation"]
["Engineering","Producing Engineering Drawings using CAD",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B31)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A31)>=1,\"\",ROW()))","v":31},"Producing Engineering Drawings using CAD"]
["Engineering","Carrying Out Routine Service Tasks on a Motor Vehicle",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B32)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A32)>=1,\"\",ROW()))","v":32},"Carrying Out Routine Service Tasks on a Motor Vehicle"]
["Health and Social Care","Communication Skills for Health and Social Care",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B33)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A33)>=1,\"\",ROW()))","v":33},"Communication Skills for Health and Social Care"]
["Health and Social Care","Making Healthy Snacks When Caring for People",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B34)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A34)>=1,\"\",ROW()))","v":34},"Making Healthy Snacks When Caring for People"]
["Health and Social Care","Advising Others About Healthy Lifestyles",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B35)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A35)>=1,\"\",ROW()))","v":35},"Advising Others About Healthy Lifestyles"]
["Health and Social Care","Measuring Older Adults’ Fitness Levels for Everyday Tasks",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B36)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A36)>=1,\"\",ROW()))","v":36},"Measuring Older Adults’ Fitness Levels for Everyday Tasks"]
["Hospitality","Preparing and Cooking Food",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B37)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A37)>=1,\"\",ROW()))","v":37},"Preparing and Cooking Food"]
["Hospitality","Serving Food and Drink",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B38)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A38)>=1,\"\",ROW()))","v":38},"Serving Food and Drink"]
["Hospitality","Exploring Local Visitor Attractions",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B39)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A39)>=1,\"\",ROW()))","v":39},"Exploring Local Visitor Attractions"]
["Hospitality","Exploring Travel and Tourism in the UK",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B40)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A40)>=1,\"\",ROW()))","v":40},"Exploring Travel and Tourism in the UK"]
["Hospitality","Delivering Customer Service in Hospitality and Tourism",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B41)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A41)>=1,\"\",ROW()))","v":41},"Delivering Customer Service in Hospitality and Tourism"]
["IT","Developing Digital Information Using IT",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B42)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A42)>=1,\"\",ROW()))","v":42},"Developing Digital Information Using IT"]
["IT","Using Digital Communication Technologies",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B43)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A43)>=1,\"\",ROW()))","v":43},"Using Digital Communication Technologies"]
["IT","Creating a Spreadsheet to Solve Problems",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B44)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A44)>=1,\"\",ROW()))","v":44},"Creating a Spreadsheet to Solve Problems"]
["IT","Creating a Website",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B45)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A45)>=1,\"\",ROW()))","v":45},"Creating a Website"]
["Land-based Studies","Caring for and Feeding Animals",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B46)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A46)>=1,\"\",ROW()))","v":46},"Caring for and Feeding Animals"]
["Land-based Studies","Moving and Accommodating Animals",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B47)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A47)>=1,\"\",ROW()))","v":47},"Moving and Accommodating Animals"]
["Land-based Studies","Growing Plants",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B48)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A48)>=1,\"\",ROW()))","v":48},"Growing Plants"]
["Land-based Studies","Preparing Soil for Planting",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B49)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A49)>=1,\"\",ROW()))","v":49},"Preparing Soil for Planting"]
["Performing Arts","Using a Stimulus for Performance",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B50)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A50)>=1,\"\",ROW()))","v":50},"Using a Stimulus for Performance"]
["Performing Arts","Performing a Dance Routine",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B51)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A51)>=1,\"\",ROW()))","v":51},"Performing a Dance Routine"]
["Performing Arts","Performing a Piece of Music",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B52)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A52)>=1,\"\",ROW()))","v":52},"Performing a Piece of Music"]
["Performing Arts","Acting in a Performance",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B53)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A53)>=1,\"\",ROW()))","v":53},"Acting in a Performance"]
["Performing Arts","Rehearsing for a Performance",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B54)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A54)>=1,\"\",ROW()))","v":54},"Rehearsing for a Performance"]
["Public Services","Taking Part in Fitness Testing",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B55)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A55)>=1,\"\",ROW()))","v":55},"Taking Part in Fitness Testing"]
["Public Services","Responding to an Incident",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B56)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A56)>=1,\"\",ROW()))","v":56},"Responding to an Incident"]
["Public Services","Planning and Navigating a Route",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B57)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A57)>=1,\"\",ROW()))","v":57},"Planning and Navigating a Route"]
["Public Services","Contributing to your Community",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B58)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A58)>=1,\"\",ROW()))","v":58},"Contributing to your Community"]
["Sport","Playing Sport",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B59)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A59)>=1,\"\",ROW()))","v":59},"Playing Sport"]
["Sport","Assisting in a Sports Activity",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B60)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A60)>=1,\"\",ROW()))","v":60},"Assisting in a Sports Activity"]
["Sport","Getting People Active",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B61)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A61)>=1,\"\",ROW()))","v":61},"Getting People Active"]
["Sport","Keeping Active and Healthy",{"$f":"IF(COUNTIF(Award!$E$12:$E$72,B62)>=1,\"\",IF(COUNTIF(Award!$F$12:$F$13,'Award Dropdown'!A62)>=1,\"\",ROW()))","v":62},"Keeping Active and Healthy"]

{"sheet":"Sectors","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Vocational Studies",null,"Applied Science",null,"Applied Science"]
[null,null,"Art and Design",null,"Art and Design"]
[null,null,"Business",null,"Business"]
[null,null,"Caring for Children",null,"Caring for Children"]
[null,null,"Construction",null,"Construction"]
[null,null,"Digital Media",null,"Digital Media"]
[null,null,"Engineering",null,"Engineering"]
[null,null,"Health and Social Care",null,"Health and Social Care"]
[null,null,"Hospitality and Tourism",null,"Hospitality and Tourism"]
[null,null,"Information Technology",null,"Information Technology"]
[null,null,"Land based Studies",null,"Land based Studies"]
[null,null,"Performing Arts",null,"Performing Arts"]
[null,null,"Public Services",null,"Public Services"]
[null,null,"Sport",null,"Sport"]
[null,null,"Vocational Studies",null,"Vocational Studies"]

{"sheet":"Lookup","index":4,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["U"]
["P"]
["M"]
["D"]

{"sheet":"Start","index":5,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,24,13],[1,1,3,14],[5,2,7,6],[5,9,7,13],[10,2,12,6],[10,9,12,13],[15,2,17,6],[15,9,17,13]]}
[]
[null,"Select the size of qualification"]
[]
[]
[]
[null,null,"Diploma",null,null,null,null,null,null,"Certificate"]
[]
[]
[]
[]
[null,null,"Award"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disclaimer: Please read carefully."]
[null,null,"Please remember that this tool is useful for calculating a learner's overall BTEC grade or helping to estimate a learner's achievement. It is NOT in any way a guarantee of any grade or outcome. "]

{"sheet":"Award","index":6,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,13,1,15],[7,8,7,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Points for Units"]
[null,null,"Select Sector",null,null,null,null,null,null,null,null,null,null,null,"30 GLH","40 GLH"]
[null,null,null,null,"1. Select your sector from the dropdown list in the cell above",null,null,null,null,null,null,null,null,"U",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P",6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M",12,16]
[null,null,null,"Unit Number","Unit Name","Sector",null,null,"GLH","Unit Grade","Points","GLH completed",null,"D",18,24]
[null,null,null,null,null,null,null,null,"3. Enter the  grade for the units below"]
[null,null,"Core",{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$F$238,SMALL(IF('Award Data Sheet'!$A$3:$A$238=$E$3,ROW('Award Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$F$238,SMALL(IF('Award Data Sheet'!$A$3:$A$238=$E$3,ROW('Award Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Award Data Sheet'!$A$3:$F$238,SMALL(IF('Award Data Sheet'!$A$3:$A$238=$E$3,ROW('Award Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,4),\"\")","v":0},null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Points!$A$2:$C$6,MATCH(Award!I9&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K9=0,K9=\"\"),0,I9)","v":0}]
[null,null,null,null,"2. Select optional units from the dropdown lists below"]
[null,null,"Choose two optional units (no more than 1 unit can be taken from each sector)"]
[null,null,"Optional",{"$f":"IF($E12=\"\",\"\",VLOOKUP($E12,'Award Data Sheet'!$G$2:$K$63,MATCH(\"Unit Number\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E12=\"\",\"\",VLOOKUP($E12,'Award Data Sheet'!$G$2:$K$63,MATCH(\"Sector\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E12=\"\",\"\",VLOOKUP($E12,'Award Data Sheet'!$G$2:$K$63,MATCH(\"GLH\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,Points!$A$2:$C$6,MATCH(Award!I12&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K12=0,K12=\"\"),0,I12)","v":0}]
[null,null,"Optional",{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Award Data Sheet'!$G$2:$K$63,MATCH(\"Unit Number\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Award Data Sheet'!$G$2:$K$63,MATCH(\"Sector\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Award Data Sheet'!$G$2:$K$63,MATCH(\"GLH\",'Award Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,Points!$A$2:$C$6,MATCH(Award!I13&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K13=0,K13=\"\"),0,I13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K13)","v":0},{"$f":"SUM(L9,L12,L13)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Overall Grade",{"$f":"IF($L$14<110,\"U\",VLOOKUP($K$14,Points!$E$2:$F$6,MATCH(\"Award Grade\",Points!$E$2:$F$2,0),TRUE))","v":"U"}]
[null,null,null,null,null,null,null,null,"Points",{"$f":"K14","v":0}]

{"sheet":"Certificate","index":7,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,13,1,15],[7,8,7,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Points for Units"]
[null,null,"Select Sector",null,null,null,null,null,null,null,null,null,null,null,"30 GLH","40 GLH"]
[null,null,null,null,"1. Select your sector from the dropdown list in the cell above",null,null,null,null,null,null,null,null,"U",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P",6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M",12,16]
[null,null,null,"Unit Number","Unit Name","Sector",null,null,"GLH","Unit Grade","Points","GLH completed",null,"D",18,24]
[null,null,null,null,null,null,null,null,"3. Enter the  grade for the units below"]
[null,null,"Core",{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,4),\"\")","v":0},null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Points!$A$2:$C$6,MATCH(Certificate!I9&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K9=0,K9=\"\"),0,I9)","v":0}]
[null,null,"Core",{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Cert Data Sheet'!$A$3:$F$238,SMALL(IF('Cert Data Sheet'!$A$3:$A$238=$E$3,ROW('Cert Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,4),\"\")","v":0},null,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,Points!$A$2:$C$6,MATCH(Certificate!I10&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K10=0,K10=\"\"),0,I10)","v":0}]
[null,null,null,null,"2. Select optional units from the dropdown lists below"]
[null,null,"Choose two optional units (no more than 1 unit can be taken from each sector)"]
[null,null,"Optional",{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E13=\"\",\"\",VLOOKUP($E13,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,Points!$A$2:$C$6,MATCH(Certificate!I13&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K13=0,K13=\"\"),0,I13)","v":0}]
[null,null,"Optional",{"$f":"IF($E14=\"\",\"\",VLOOKUP($E14,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E14=\"\",\"\",VLOOKUP($E14,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E14=\"\",\"\",VLOOKUP($E14,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J14=\"\",\"\",VLOOKUP(J14,Points!$A$2:$C$6,MATCH(Certificate!I14&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K14=0,K14=\"\"),0,I14)","v":0}]
[null,null,"Optional",{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Cert Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Cert Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,Points!$A$2:$C$6,MATCH(Certificate!I15&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K15=0,K15=\"\"),0,I15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K15)","v":0},{"$f":"SUM(L9,L10,L13,L14,L15)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Overall Grade",{"$f":"IF($L$16<140,\"U\",VLOOKUP($K$16,Points!$H$2:$J$6,MATCH(\"Cert Grade\",Points!$H$2:$J$2,0),TRUE))","v":"U"}]
[null,null,null,null,null,null,null,null,"Points",{"$f":"K16","v":0}]

{"sheet":"Diploma","index":8,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,13,1,15],[7,8,7,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Points for Units"]
[null,null,"Select Sector",null,null,null,null,null,null,null,null,null,null,null,"30 GLH","40 GLH"]
[null,null,null,null,"1. Select your sector from the dropdown list in the cell above",null,null,null,null,null,null,null,null,"U",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"P",6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M",12,16]
[null,null,null,"Unit Number","Unit Name","Sector",null,null,"GLH","Unit Grade","Points","GLH completed",null,"D",18,24]
[null,null,null,null,null,null,null,null,"3. Enter the  grade for the units below"]
[null,null,"Core",{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(1:1))-2,4),\"\")","v":0},null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,Points!$A$2:$C$6,MATCH(Diploma!I9&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K9=0,K9=\"\"),0,I9)","v":0}]
[null,null,"Core",{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(2:2))-2,4),\"\")","v":0},null,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,Points!$A$2:$C$6,MATCH(I10&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K10=0,K10=\"\"),0,I10)","v":0}]
[null,null,"Core",{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(3:3))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(3:3))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(3:3))-2,4),\"\")","v":0},null,{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,Points!$A$2:$C$6,MATCH(I11&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,"Core",{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(4:4))-2,2),\"\")","v":0},{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(4:4))-2,3),\"\")","v":0},null,null,null,{"$f":"IFERROR(INDEX('Dip Data Sheet'!$A$3:$F$238,SMALL(IF('Dip Data Sheet'!$A$3:$A$238=$E$3,ROW('Dip Data Sheet'!$A$3:$A$238)),ROW(4:4))-2,4),\"\")","v":0},null,{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,Points!$A$2:$C$6,MATCH(I12&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,null,null,"2. Select optional units from the dropdown lists below"]
[null,null,"Choose two optional units (no more than 1 unit can be taken from each sector)"]
[null,null,"Optional",{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E15=\"\",\"\",VLOOKUP($E15,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,Points!$A$2:$C$6,MATCH(I15&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K15=0,K15=\"\"),0,I15)","v":0}]
[null,null,"Optional",{"$f":"IF($E16=\"\",\"\",VLOOKUP($E16,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E16=\"\",\"\",VLOOKUP($E16,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E16=\"\",\"\",VLOOKUP($E16,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J16=\"\",\"\",VLOOKUP(J16,Points!$A$2:$C$6,MATCH(I16&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},{"$f":"IF(OR(K16=0,K16=\"\"),0,I16)","v":0}]
[null,null,"Optional",{"$f":"IF($E17=\"\",\"\",VLOOKUP($E17,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E17=\"\",\"\",VLOOKUP($E17,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E17=\"\",\"\",VLOOKUP($E17,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J17=\"\",\"\",VLOOKUP(J17,Points!$A$2:$C$6,MATCH(I17&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,"Optional",{"$f":"IF($E18=\"\",\"\",VLOOKUP($E18,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E18=\"\",\"\",VLOOKUP($E18,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E18=\"\",\"\",VLOOKUP($E18,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J18=\"\",\"\",VLOOKUP(J18,Points!$A$2:$C$6,MATCH(I18&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,"Optional",{"$f":"IF($E19=\"\",\"\",VLOOKUP($E19,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E19=\"\",\"\",VLOOKUP($E19,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E19=\"\",\"\",VLOOKUP($E19,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J19=\"\",\"\",VLOOKUP(J19,Points!$A$2:$C$6,MATCH(I19&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,"Optional",{"$f":"IF($E20=\"\",\"\",VLOOKUP($E20,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Unit Number\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF($E20=\"\",\"\",VLOOKUP($E20,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"Sector\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,null,{"$f":"IF($E20=\"\",\"\",VLOOKUP($E20,'Dip Data Sheet'!$G$2:$K$999,MATCH(\"GLH\",'Dip Data Sheet'!$G$2:$K$2,0),FALSE))","v":""},null,{"$f":"IF(J20=\"\",\"\",VLOOKUP(J20,Points!$A$2:$C$6,MATCH(I20&\" \"&\"GLH\",Points!$A$2:$C$2,0),FALSE))","v":""},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K20)","v":0},{"$f":"SUM(L9:L12,L15:L20)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Overall Grade",{"$f":"IF($L$21<280,\"U\",VLOOKUP($K$21,Points!$K$2:$L$8,MATCH(\"Dip Grade\",Points!$K$2:$L$2,0),TRUE))","v":"U"}]
[null,null,null,null,null,null,null,null,"Points",{"$f":"K21","v":0}]

{"sheet":"Dip Data Sheet","index":9,"n_rows":175,"n_cols":11,"rows_kept":175,"cut":false,"hidden":true,"merged":[]}
["Core units A",null,null,null,null,null,null,"Optional Units"]
["Sector","Unit number","Unit Name","GLH",null,null,null,"Sector","Unit Number","Unit Name","GLH"]
["Applied Science","A1","Being Organised",30,null,"Applied Science","Testing the Quality of Products","Applied Science","ASc5","Testing the Quality of Products",40]
["Applied Science","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Carrying Out a Scientific Experiment","Applied Science","ASc6","Carrying Out a Scientific Experiment",40]
["Applied Science","A3","Working with Others",30,null,"Applied Science","Investigating Variations in Plants and Animals","Applied Science","ASc7","Investigating Variations in Plants and Animals",40]
["Applied Science","A4","Researching a Topic",30,null,"Applied Science","Measuring Waves Used in Technology","Applied Science","ASc8","Measuring Waves Used in Technology",40]
["Art and Design","A1","Being Organised",30,null,"Applied Science","Practical Actions to Protect the Environment","Applied Science","ASc9","Practical Actions to Protect the Environment",40]
["Art and Design","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Making a Chemical Product","Applied Science","ASc10","Making a Chemical Product",40]
["Art and Design","A3","Working with Others",30,null,"Applied Science","Testing the Properties of Products","Applied Science","ASc11","Testing the Properties of Products",40]
["Art and Design","A4","Researching a Topic",30,null,"Applied Science","Investigating Crime Scene Evidence","Applied Science","ASc12","Investigating Crime Scene Evidence",40]
["Business","A1","Being Organised",30,null,"Art and Design","Creating an Art Image","Art and Design","AD5","Creating an Art Image",40]
["Business","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Creating a 3D Art Object","Art and Design","AD6","Creating a 3D Art Object",40]
["Business","A3","Working with Others",30,null,"Art and Design","Presenting an Image Using a Camera","Art and Design","AD7","Presenting an Image Using a Camera",40]
["Business","A4","Researching a Topic",30,null,"Art and Design","Designing a Product","Art and Design","AD8","Designing a Product",40]
["Caring for Children","A1","Being Organised",30,null,"Art and Design","Planning and Marketing an Exhibition","Art and Design","AD9","Planning and Marketing an Exhibition",40]
["Caring for Children","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Creating a Mood Board","Art and Design","AD10","Creating a Mood Board",40]
["Caring for Children","A3","Working with Others",30,null,"Art and Design","Creating an Artefact Using Clay","Art and Design","AD11","Creating an Artefact Using Clay",40]
["Caring for Children","A4","Researching a Topic",30,null,"Art and Design","Creating Prints","Art and Design","AD12","Creating Prints",40]
["Construction","A1","Being Organised",30,null,"Business","Finding Out About Businesses in Your Area","Business","B5","Finding Out About Businesses in Your Area",40]
["Construction","A2","Developing a Personal Progression Plan",30,null,"Business","Organising a Meeting","Business","B6","Organising a Meeting",40]
["Construction","A3","Working with Others",30,null,"Business","Branding a Product","Business","B7","Branding a Product",40]
["Construction","A4","Researching a Topic",30,null,"Business","Creating a Visual Display","Business","B8","Creating a Visual Display",40]
["Digital Media","A1","Being Organised",30,null,"Business","Presenting a Business Idea","Business","B9","Presenting a Business Idea",40]
["Digital Media","A2","Developing a Personal Progression Plan",30,null,"Business","Contributing to Running an Event","Business","B10","Contributing to Running an Event",40]
["Digital Media","A3","Working with Others",30,null,"Business","Recording Income and Expenditure","Business","B11","Recording Income and Expenditure",40]
["Digital Media","A4","Researching a Topic",30,null,"Business","Communicating with Customers","Business","B12","Communicating with Customers",40]
["Engineering","A1","Being Organised",30,null,"Caring for Children","Providing an Activity to Support Children’s Emotional and Social Needs","Caring for Children","CfC5","Providing an Activity to Support Children’s Emotional and Social Needs",40]
["Engineering","A2","Developing a Personal Progression Plan",30,null,"Caring for Children","Planning a Safe Childcare Environment","Caring for Children","CfC6","Planning a Safe Childcare Environment",40]
["Engineering","A3","Working with Others",30,null,"Caring for Children","Providing an Activity to Encourage Children to Eat Healthily","Caring for Children","CfC7","Providing an Activity to Encourage Children to Eat Healthily",40]
["Engineering","A4","Researching a Topic",30,null,"Caring for Children","Providing a Pre-school Children’s Reading Activity","Caring for Children","CfC8","Providing a Pre-school Children’s Reading Activity",40]
["Health and Social Care","A1","Being Organised",30,null,"Caring for Children","Providing an Activity to Support Children’s Numeracy","Caring for Children","CfC9","Providing an Activity to Support Children’s Numeracy",40]
["Health and Social Care","A2","Developing a Personal Progression Plan",30,null,"Caring for Children","Providing a Children’s Creative Activity","Caring for Children","CfC10","Providing a Children’s Creative Activity",40]
["Health and Social Care","A3","Working with Others",30,null,"Caring for Children","Providing a Children’s Physical Activity","Caring for Children","CfC11","Providing a Children’s Physical Activity",40]
["Health and Social Care","A4","Researching a Topic",30,null,"Caring for Children","Supporting Children’s Learning Through Everyday Experiences","Caring for Children","CfC12","Supporting Children’s Learning Through Everyday Experiences",40]
["Hospitality and Tourism","A1","Being Organised",30,null,"Construction","Drawing a Plan of a Room","Construction","CON5","Drawing a Plan of a Room",40]
["Hospitality and Tourism","A2","Developing a Personal Progression Plan",30,null,"Construction","Building a Simple Wall","Construction","CON6","Building a Simple Wall",40]
["Hospitality and Tourism","A3","Working with Others",30,null,"Construction","Making Carpentry Joints","Construction","CON7","Making Carpentry Joints",40]
["Hospitality and Tourism","A4","Researching a Topic",30,null,"Construction","Fixing a Water Pipe","Construction","CON8","Fixing a Water Pipe",40]
["Information Technology","A1","Being Organised",30,null,"Construction","Costing a Small Repair Job","Construction","CON9","Costing a Small Repair Job",40]
["Information Technology","A2","Developing a Personal Progression Plan",30,null,"Construction","Making Minor Repairs in a House","Construction","CON10","Making Minor Repairs in a House",40]
["Information Technology","A3","Working with Others",30,null,"Construction","Decorating an Inside Wall","Construction","CON11","Decorating an Inside Wall",40]
["Information Technology","A4","Researching a Topic",30,null,"Construction","Making an Electrical Circuit","Construction","CON12","Making an Electrical Circuit",40]
["Land based Studies","A1","Being Organised",30,null,"Digital Media","Creating a Storyboard","Digital Media","DM5","Creating a Storyboard",40]
["Land based Studies","A2","Developing a Personal Progression Plan",30,null,"Digital Media","Designing an Interactive Presentation","Digital Media","DM6","Designing an Interactive Presentation",40]
["Land based Studies","A3","Working with Others",30,null,"Digital Media","Producing an Advert","Digital Media","DM7","Producing an Advert",40]
["Land based Studies","A4","Researching a Topic",30,null,"Digital Media","Layout Design for a Digital Product","Digital Media","DM8","Layout Design for a Digital Product",40]
["Performing Arts","A1","Being Organised",30,null,"Digital Media","Creating an Animation","Digital Media","DM9","Creating an Animation",40]
["Performing Arts","A2","Developing a Personal Progression Plan",30,null,"Digital Media","Shooting a Short Film","Digital Media","DM10","Shooting a Short Film",40]
["Performing Arts","A3","Working with Others",30,null,"Digital Media","Making an Audio Recording","Digital Media","DM11","Making an Audio Recording",40]
["Performing Arts","A4","Researching a Topic",30,null,"Digital Media","Editing and Sharing a Media Product","Digital Media","DM12","Editing and Sharing a Media Product",40]
["Public Services","A1","Being Organised",30,null,"Engineering","Manufacturing an Engineered Product Using Hand Tools","Engineering","ENG5","Manufacturing an Engineered Product Using Hand Tools",40]
["Public Services","A2","Developing a Personal Progression Plan",30,null,"Engineering","Manufacturing a Component Using Machining Processes","Engineering","ENG6","Manufacturing a Component Using Machining Processes",40]
["Public Services","A3","Working with Others",30,null,"Engineering","Using a Welding Process to Join Materials","Engineering","ENG7","Using a Welding Process to Join Materials",40]
["Public Services","A4","Researching a Topic",30,null,"Engineering","Assembling Electronic Circuits","Engineering","ENG8","Assembling Electronic Circuits",40]
["Sport","A1","Being Organised",30,null,"Engineering","Carrying Out Routine Mechanical Servicing of Equipment","Engineering","ENG9","Carrying Out Routine Mechanical Servicing of Equipment",40]
["Sport","A2","Developing a Personal Progression Plan",30,null,"Engineering","Carrying Out an Electrical Installation","Engineering","ENG10","Carrying Out an Electrical Installation",40]
["Sport","A3","Working with Others",30,null,"Engineering","Producing Engineering Drawings Using CAD","Engineering","ENG11","Producing Engineering Drawings Using CAD",40]
["Sport","A4","Researching a Topic",30,null,"Engineering","Carrying Out Routine Service Tasks on a Motor Vehicle","Engineering","ENG12","Carrying Out Routine Service Tasks on a Motor Vehicle",40]
["Vocational Studies","A1","Being Organised",30,null,"Health and Social Care","Finding Out About Health and Social Care Services","Health and Social Care","HSC5","Finding Out About Health and Social Care Services",40]
["Vocational Studies","A2","Developing a Personal Progression Plan",30,null,"Health and Social Care","Communication Skills for Health and Social Care","Health and Social Care","HSC6","Communication Skills for Health and Social Care",40]
["Vocational Studies","A3","Working with Others",30,null,"Health and Social Care","Making Healthy Snacks When Caring for People","Health and Social Care","HSC7","Making Healthy Snacks When Caring for People",40]
["Vocational Studies","A4","Researching a Topic",30,null,"Health and Social Care","Advising Others About Healthy Lifestyles","Health and Social Care","HSC8","Advising Others About Healthy Lifestyles",40]
[null,null,null,null,null,"Health and Social Care","Providing a Creative Activity When Caring for People","Health and Social Care","HSC9","Providing a Creative Activity When Caring for People",40]
[null,null,null,null,null,"Health and Social Care","Supporting Others to Use Adapted Equipment Safely","Health and Social Care","HSC10","Supporting Others to Use Adapted Equipment Safely",40]
[null,null,null,null,null,"Health and Social Care","Measuring Older Adults’ Fitness Levels for Everyday Tasks","Health and Social Care","HSC11","Measuring Older Adults’ Fitness Levels for Everyday Tasks",40]
[null,null,null,null,null,"Health and Social Care","Visiting a Health or Social Care Setting","Health and Social Care","HSC12","Visiting a Health or Social Care Setting",40]
[null,null,null,null,null,"Hospitality and Tourism","Preparing and Cooking Food","Hospitality and Tourism","HT5","Preparing and Cooking Food",40]
[null,null,null,null,null,"Hospitality and Tourism","Serving Food and Drink","Hospitality and Tourism","HT6","Serving Food and Drink",40]
[null,null,null,null,null,"Hospitality and Tourism","Exploring Local Visitor Attractions","Hospitality and Tourism","HT7","Exploring Local Visitor Attractions",40]
[null,null,null,null,null,"Hospitality and Tourism","Exploring Travel and Tourism in the UK","Hospitality and Tourism","HT8","Exploring Travel and Tourism in the UK",40]
[null,null,null,null,null,"Hospitality and Tourism","Contribute to Running a Hospitality and Tourism Event","Hospitality and Tourism","HT9","Contribute to Running a Hospitality and Tourism Event",40]
[null,null,null,null,null,"Hospitality and Tourism","Delivering Customer Service in Hospitality and Tourism","Hospitality and Tourism","HT10","Delivering Customer Service in Hospitality and Tourism",40]
[null,null,null,null,null,"Hospitality and Tourism","Using Websites to Make Holiday Choices","Hospitality and Tourism","HT11","Using Websites to Make Holiday Choices",40]
[null,null,null,null,null,"Hospitality and Tourism","Promoting Hospitality and Tourism Events","Hospitality and Tourism","HT12","Promoting Hospitality and Tourism Events",40]
[null,null,null,null,null,"Information Technology","Developing Digital Information Using IT","Information Technology","IT5","Developing Digital Information Using IT",40]
[null,null,null,null,null,"Information Technology","Using Digital Communication Technologies","Information Technology","IT6","Using Digital Communication Technologies",40]
[null,null,null,null,null,"Information Technology","Solving Technical IT Problems","Information Technology","IT7","Solving Technical IT Problems",40]
[null,null,null,null,null,"Information Technology","Creating a Spreadsheet to Solve Problems","Information Technology","IT8","Creating a Spreadsheet to Solve Problems",40]
[null,null,null,null,null,"Information Technology","Creating a Website","Information Technology","IT9","Creating a Website",40]
[null,null,null,null,null,"Information Technology","Creating a Computer Program","Information Technology","IT10","Creating a Computer Program",40]
[null,null,null,null,null,"Information Technology","Developing a Digital Product","Information Technology","IT11","Developing a Digital Product",40]
[null,null,null,null,null,"Information Technology","Creating a Digital Animated Graphic","Information Technology","IT12","Creating a Digital Animated Graphic",40]
[null,null,null,null,null,"Land based Studies","Finding Out About the Land-based Sector","Land based Studies","LBS5","Finding Out About the Land-based Sector",40]
[null,null,null,null,null,"Land based Studies","Caring for and Feeding Animals","Land based Studies","LBS6","Caring for and Feeding Animals",40]
[null,null,null,null,null,"Land based Studies","Moving and Accommodating Animals","Land based Studies","LBS7","Moving and Accommodating Animals",40]
[null,null,null,null,null,"Land based Studies","Growing Plants","Land based Studies","LBS8","Growing Plants",40]
[null,null,null,null,null,"Land based Studies","Caring for and Keeping Plants Healthy","Land based Studies","LBS9","Caring for and Keeping Plants Healthy",40]
[null,null,null,null,null,"Land based Studies","Using Workshop Tools in a Land-based Setting","Land based Studies","LBS10","Using Workshop Tools in a Land-based Setting",40]
[null,null,null,null,null,"Land based Studies","Using Land-based Machinery","Land based Studies","LBS11","Using Land-based Machinery",40]
[null,null,null,null,null,"Land based Studies","Preparing Soil for Planting","Land based Studies","LBS12","Preparing Soil for Planting",40]
[null,null,null,null,null,"Performing Arts","Using a Stimulus for Performance","Performing Arts","PA5","Using a Stimulus for Performance",40]
[null,null,null,null,null,"Performing Arts","Designing Technical Support","Performing Arts","PA6","Designing Technical Support",40]
[null,null,null,null,null,"Performing Arts","Providing Technical Support","Performing Arts","PA7","Providing Technical Support",40]
[null,null,null,null,null,"Performing Arts","Performing a Dance Routine","Performing Arts","PA8","Performing a Dance Routine",40]
[null,null,null,null,null,"Performing Arts","Performing a Piece of Music","Performing Arts","PA9","Performing a Piece of Music",40]
[null,null,null,null,null,"Performing Arts","Acting in a Performance","Performing Arts","PA10","Acting in a Performance",40]
[null,null,null,null,null,"Performing Arts","Personal Preparation for Performance","Performing Arts","PA11","Personal Preparation for Performance",40]
[null,null,null,null,null,"Performing Arts","Rehearsing for a Performance","Performing Arts","PA12","Rehearsing for a Performance",40]
[null,null,null,null,null,"Public Services","Finding Out about Public Services","Public Services","PS5","Finding Out about Public Services",40]
[null,null,null,null,null,"Public Services","Taking Part in Fitness Testing","Public Services","PS6","Taking Part in Fitness Testing",40]
[null,null,null,null,null,"Public Services","Carrying out Security Searches","Public Services","PS7","Carrying out Security Searches",40]
[null,null,null,null,null,"Public Services","Responding to an Incident","Public Services","PS8","Responding to an Incident",40]
[null,null,null,null,null,"Public Services","Planning and Navigating a Route","Public Services","PS9","Planning and Navigating a Route",40]
[null,null,null,null,null,"Public Services","Assisting Members of the Public","Public Services","PS10","Assisting Members of the Public",40]
[null,null,null,null,null,"Public Services","Contributing to your Community","Public Services","PS11","Contributing to your Community",40]
[null,null,null,null,null,"Public Services","Taking Part in Sport and Adventurous Activities","Public Services","PS12","Taking Part in Sport and Adventurous Activities",40]
[null,null,null,null,null,"Sport","How Exercise Affects the Body","Sport","SP5","How Exercise Affects the Body",40]
[null,null,null,null,null,"Sport","Training for Fitness","Sport","SP6","Training for Fitness",40]
[null,null,null,null,null,"Sport","Playing Sport","Sport","SP7","Playing Sport",40]
[null,null,null,null,null,"Sport","Coaching Skills in Sport","Sport","SP8","Coaching Skills in Sport",40]
[null,null,null,null,null,"Sport","Assisting in a Sports Activity","Sport","SP9","Assisting in a Sports Activity",40]
[null,null,null,null,null,"Sport","Contributing to Running a Sports Event","Sport","SP10","Contributing to Running a Sports Event",40]
[null,null,null,null,null,"Sport","Getting People Active","Sport","SP11","Getting People Active",40]
[null,null,null,null,null,"Sport","Keeping Active and Healthy","Sport","SP12","Keeping Active and Healthy",40]
[null,null,null,null,null,"Vocational Studies","Creating an Art Image","Art and Design","AD5","Creating an Art Image",40]
[null,null,null,null,null,"Vocational Studies","Designing a Product","Art and Design","AD8","Designing a Product",40]
[null,null,null,null,null,"Vocational Studies","Creating a Mood Board","Art and Design","AD10","Creating a Mood Board",40]
[null,null,null,null,null,"Vocational Studies","Creating Prints","Art and Design","AD12","Creating Prints",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out a Scientific Experiment","Applied Science","ASc6","Carrying Out a Scientific Experiment",40]
[null,null,null,null,null,"Vocational Studies","Practical Actions to Protect the Environment","Applied Science","ASc9","Practical Actions to Protect the Environment",40]
[null,null,null,null,null,"Vocational Studies","Making a Chemical Product","Applied Science","ASc10","Making a Chemical Product",40]
[null,null,null,null,null,"Vocational Studies","Investigating Crime Scene Evidence","Applied Science","ASc12","Investigating Crime Scene Evidence",40]
[null,null,null,null,null,"Vocational Studies","Organising a Meeting","Business","B6","Organising a Meeting",40]
[null,null,null,null,null,"Vocational Studies","Branding a Product","Business","B7","Branding a Product",40]
[null,null,null,null,null,"Vocational Studies","Presenting a Business Idea","Business","B9","Presenting a Business Idea",40]
[null,null,null,null,null,"Vocational Studies","Contribute to Running an Event","Business","B10","Contribute to Running an Event",40]
[null,null,null,null,null,"Vocational Studies","Recording Income and Expenditure","Business","B11","Recording Income and Expenditure",40]
[null,null,null,null,null,"Vocational Studies","Communicating with Customers","Business","B12","Communicating with Customers",40]
[null,null,null,null,null,"Vocational Studies","Providing an Activity to Support Children’s Emotional and Social Needs","Caring for Children","CfC5","Providing an Activity to Support Children’s Emotional and Social Needs",40]
[null,null,null,null,null,"Vocational Studies","Planning a Safe Childcare Environment","Caring for Children","CfC6","Planning a Safe Childcare Environment",40]
[null,null,null,null,null,"Vocational Studies","Providing a Children’s Creative Activity","Caring for Children","CfC10","Providing a Children’s Creative Activity",40]
[null,null,null,null,null,"Vocational Studies","Supporting Children’s Learning Through Everyday Experiences","Caring for Children","CfC12","Supporting Children’s Learning Through Everyday Experiences",40]
[null,null,null,null,null,"Vocational Studies","Drawing a Plan of a Room","Construction","CON5","Drawing a Plan of a Room",40]
[null,null,null,null,null,"Vocational Studies","Building a Simple Wall","Construction","CON6","Building a Simple Wall",40]
[null,null,null,null,null,"Vocational Studies","Making Carpentry Joints","Construction","CON7","Making Carpentry Joints",40]
[null,null,null,null,null,"Vocational Studies","Fixing a Water Pipe","Construction","CON8","Fixing a Water Pipe",40]
[null,null,null,null,null,"Vocational Studies","Making an Electrical Circuit","Construction","CON12","Making an Electrical Circuit",40]
[null,null,null,null,null,"Vocational Studies","Creating a Storyboard","Digital Media","DM5","Creating a Storyboard",40]
[null,null,null,null,null,"Vocational Studies","Designing an Interactive Presentation","Digital Media","DM6","Designing an Interactive Presentation",40]
[null,null,null,null,null,"Vocational Studies","Creating an Animation","Digital Media","DM9","Creating an Animation",40]
[null,null,null,null,null,"Vocational Studies","Shooting a Short Film","Digital Media","DM10","Shooting a Short Film",40]
[null,null,null,null,null,"Vocational Studies","Manufacturing an Engineered Product Using Hand Tools","Engineering","ENG5","Manufacturing an Engineered Product Using Hand Tools",40]
[null,null,null,null,null,"Vocational Studies","Carrying out Electrical Installation","Engineering","ENG10","Carrying out Electrical Installation",40]
[null,null,null,null,null,"Vocational Studies","Producing Engineering Drawings using CAD","Engineering","ENG11","Producing Engineering Drawings using CAD",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out Routine Service Tasks on a Motor Vehicle","Engineering","ENG12","Carrying Out Routine Service Tasks on a Motor Vehicle",40]
[null,null,null,null,null,"Vocational Studies","Communication Skills for Health and Social Care","Health and Social Care","HSC6","Communication Skills for Health and Social Care",40]
[null,null,null,null,null,"Vocational Studies","Making Healthy Snacks When Caring for People","Health and Social Care","HSC7","Making Healthy Snacks When Caring for People",40]
[null,null,null,null,null,"Vocational Studies","Advising Others About Healthy Lifestyles","Health and Social Care","HSC8","Advising Others About Healthy Lifestyles",40]
[null,null,null,null,null,"Vocational Studies","Measuring Older Adults’ Fitness Levels for Everyday Tasks","Health and Social Care","HSC11","Measuring Older Adults’ Fitness Levels for Everyday Tasks",40]
[null,null,null,null,null,"Vocational Studies","Preparing and Cooking Food","Hospitality","HT5","Preparing and Cooking Food",40]
[null,null,null,null,null,"Vocational Studies","Serving Food and Drink","Hospitality","HT6","Serving Food and Drink",40]
[null,null,null,null,null,"Vocational Studies","Exploring Local Visitor Attractions","Hospitality","HT7","Exploring Local Visitor Attractions",40]
[null,null,null,null,null,"Vocational Studies","Exploring Travel and Tourism in the UK","Hospitality","HT8","Exploring Travel and Tourism in the UK",40]
[null,null,null,null,null,"Vocational Studies","Delivering Customer Service in Hospitality and Tourism","Hospitality","HT10","Delivering Customer Service in Hospitality and Tourism",40]
[null,null,null,null,null,"Vocational Studies","Developing Digital Information Using IT","IT","IT5","Developing Digital Information Using IT",40]
[null,null,null,null,null,"Vocational Studies","Using Digital Communication Technologies","IT","IT6","Using Digital Communication Technologies",40]
[null,null,null,null,null,"Vocational Studies","Creating a Spreadsheet to Solve Problems","IT","IT8","Creating a Spreadsheet to Solve Problems",40]
[null,null,null,null,null,"Vocational Studies","Creating a Website","IT","IT9","Creating a Website",40]
[null,null,null,null,null,"Vocational Studies","Caring for and Feeding Animals","Land-based Studies","LBS6","Caring for and Feeding Animals",40]
[null,null,null,null,null,"Vocational Studies","Moving and Accommodating Animals","Land-based Studies","LBS7","Moving and Accommodating Animals",40]
[null,null,null,null,null,"Vocational Studies","Growing Plants","Land-based Studies","LBS8","Growing Plants",40]
[null,null,null,null,null,"Vocational Studies","Preparing Soil for Planting","Land-based Studies","LBS12","Preparing Soil for Planting",40]
[null,null,null,null,null,"Vocational Studies","Using a Stimulus for Performance","Performing Arts","PA5","Using a Stimulus for Performance",40]
[null,null,null,null,null,"Vocational Studies","Performing a Dance Routine","Performing Arts","PA8","Performing a Dance Routine",40]
[null,null,null,null,null,"Vocational Studies","Performing a Piece of Music","Performing Arts","PA9","Performing a Piece of Music",40]
[null,null,null,null,null,"Vocational Studies","Acting in a Performance","Performing Arts","PA10","Acting in a Performance",40]
[null,null,null,null,null,"Vocational Studies","Rehearsing for a Performance","Performing Arts","PA12","Rehearsing for a Performance",40]
[null,null,null,null,null,"Vocational Studies","Taking Part in Fitness Testing","Public Services","PS6","Taking Part in Fitness Testing",40]
[null,null,null,null,null,"Vocational Studies","Responding to an Incident","Public Services","PS8","Responding to an Incident",40]
[null,null,null,null,null,"Vocational Studies","Planning and Navigating a Route","Public Services","PS9","Planning and Navigating a Route",40]
[null,null,null,null,null,"Vocational Studies","Contributing to your Community","Public Services","PS11","Contributing to your Community",40]
[null,null,null,null,null,"Vocational Studies","Playing Sport","Sport","SP7","Playing Sport",40]
[null,null,null,null,null,"Vocational Studies","Assisting in a Sports Activity","Sport","SP9","Assisting in a Sports Activity",40]
[null,null,null,null,null,"Vocational Studies","Getting People Active","Sport","SP11","Getting People Active",40]
[null,null,null,null,null,"Vocational Studies","Keeping Active and Healthy","Sport","SP12","Keeping Active and Healthy",40]

{"sheet":"Dip Dropdown","index":10,"n_rows":62,"n_cols":60,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Applied Science Group A",null,null,null,"Art and Design Group A",null,null,null,"Business Group A",null,null,null,"Caring for Children Group A",null,null,null,"Construction Group A",null,null,null,"Digital Media Group A",null,null,null,"Engineering Group A",null,null,null,"Health and Social Care Group A",null,null,null,"Hospitality and Tourism Group A",null,null,null,"Information Terchnology Group A",null,null,null,"Land-based Studies Group A",null,null,null,"Performing Arts Group A",null,null,null,"Public Services Group A",null,null,null,"Sport Group A",null,null,null,null,"Vocational Studies Group A"]
["Testing the Quality of Products",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(A2)-ROW(A$2)+1>COUNT(B$2:B$70),\"\",INDEX(A:A,SMALL(B$2:B$70,1+ROW(A2)-ROW(A$2))))","v":"Testing the Quality of Products"},null,"Creating an Art Image",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(E2)-ROW(E$2)+1>COUNT(F$2:F$70),\"\",INDEX(E:E,SMALL(F$2:F$70,1+ROW(E2)-ROW(E$2))))","v":"Creating an Art Image"},null,"Finding Out About Businesses in Your Area",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(I2)-ROW(I$2)+1>COUNT(J$2:J$70),\"\",INDEX(I:I,SMALL(J$2:J$70,1+ROW(I2)-ROW(I$2))))","v":"Finding Out About Businesses in Your Area"},null,"Providing an Activity to Support Children’s Emotional and Social Needs",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(M2)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M2)-ROW(M$2))))","v":"Providing an Activity to Support Children’s Emotional and Social Needs"},null,"Drawing a Plan of a Room",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(Q2)-ROW(Q$2)+1>COUNT(R$2:R$70),\"\",INDEX(Q:Q,SMALL(R$2:R$70,1+ROW(Q2)-ROW(Q$2))))","v":"Drawing a Plan of a Room"},null,"Creating a Storyboard",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(U2)-ROW(U$2)+1>COUNT(V$2:V$70),\"\",INDEX(U:U,SMALL(V$2:V$70,1+ROW(U2)-ROW(U$2))))","v":"Creating a Storyboard"},null,"Manufacturing an Engineered Product Using Hand Tools",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(Y2)-ROW(Y$2)+1>COUNT(Z$2:Z$70),\"\",INDEX(Y:Y,SMALL(Z$2:Z$70,1+ROW(Y2)-ROW(Y$2))))","v":"Manufacturing an Engineered Product Using Hand Tools"},null,"Finding Out About Health and Social Care Services",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AC2)-ROW(AC$2)+1>COUNT(AD$2:AD$70),\"\",INDEX(AC:AC,SMALL(AD$2:AD$70,1+ROW(AC2)-ROW(AC$2))))","v":"Finding Out About Health and Social Care Services"},null,"Preparing and Cooking Food",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AG2)-ROW(AG$2)+1>COUNT(AH$2:AH$70),\"\",INDEX(AG:AG,SMALL(AH$2:AH$70,1+ROW(AG2)-ROW(AG$2))))","v":"Preparing and Cooking Food"},null,"Developing Digital Information Using IT",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AK2)-ROW(AK$2)+1>COUNT(AL$2:AL$70),\"\",INDEX(AK:AK,SMALL(AL$2:AL$70,1+ROW(AK2)-ROW(AK$2))))","v":"Developing Digital Information Using IT"},null,"Finding Out About the Land-based Sector",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AO2)-ROW(AO$2)+1>COUNT(AP$2:AP$70),\"\",INDEX(AO:AO,SMALL(AP$2:AP$70,1+ROW(AO2)-ROW(AO$2))))","v":"Finding Out About the Land-based Sector"},null,"Using a Stimulus for Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AS2)-ROW(AS$2)+1>COUNT(AT$2:AT$70),\"\",INDEX(AS:AS,SMALL(AT$2:AT$70,1+ROW(AS2)-ROW(AS$2))))","v":"Using a Stimulus for Performance"},null,"Finding Out about Public Services",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AW2)-ROW(AW$2)+1>COUNT(AX$2:AX$70),\"\",INDEX(AW:AW,SMALL(AX$2:AX$70,1+ROW(AW2)-ROW(AW$2))))","v":"Finding Out about Public Services"},null,"How Exercise Affects the Body",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(BA2)-ROW(BA$2)+1>COUNT(BB$2:BB$70),\"\",INDEX(BA:BA,SMALL(BB$2:BB$70,1+ROW(BA2)-ROW(BA$2))))","v":"How Exercise Affects the Body"},null,"Art and Design","Creating an Art Image",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF2)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE2)>=3,\"\",ROW()))","v":2},{"$f":"IF(ROW(BF2)-ROW(BF$2)+1>COUNT(BG$2:BG$70),\"\",INDEX(BF:BF,SMALL(BG$2:BG$70,1+ROW(BF2)-ROW(BF$2))))","v":"Creating an Art Image"}]
["Carrying Out a Scientific Experiment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(A3)-ROW(A$2)+1>COUNT(B$2:B$70),\"\",INDEX(A:A,SMALL(B$2:B$70,1+ROW(A3)-ROW(A$2))))","v":"Carrying Out a Scientific Experiment"},null,"Creating a 3D Art Object",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(E3)-ROW(E$2)+1>COUNT(F$2:F$70),\"\",INDEX(E:E,SMALL(F$2:F$70,1+ROW(E3)-ROW(E$2))))","v":"Creating a 3D Art Object"},null,"Organising a Meeting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(I3)-ROW(I$2)+1>COUNT(J$2:J$70),\"\",INDEX(I:I,SMALL(J$2:J$70,1+ROW(I3)-ROW(I$2))))","v":"Organising a Meeting"},null,"Planning a Safe Childcare Environment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(M3)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M3)-ROW(M$2))))","v":"Planning a Safe Childcare Environment"},null,"Building a Simple Wall",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(Q3)-ROW(Q$2)+1>COUNT(R$2:R$70),\"\",INDEX(Q:Q,SMALL(R$2:R$70,1+ROW(Q3)-ROW(Q$2))))","v":"Building a Simple Wall"},null,"Designing an Interactive Presentation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(U3)-ROW(U$2)+1>COUNT(V$2:V$70),\"\",INDEX(U:U,SMALL(V$2:V$70,1+ROW(U3)-ROW(U$2))))","v":"Designing an Interactive Presentation"},null,"Manufacturing a Component Using Machining Processes",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(Y3)-ROW(Y$2)+1>COUNT(Z$2:Z$70),\"\",INDEX(Y:Y,SMALL(Z$2:Z$70,1+ROW(Y3)-ROW(Y$2))))","v":"Manufacturing a Component Using Machining Processes"},null,"Communication Skills for Health and Social Care",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AC3)-ROW(AC$2)+1>COUNT(AD$2:AD$70),\"\",INDEX(AC:AC,SMALL(AD$2:AD$70,1+ROW(AC3)-ROW(AC$2))))","v":"Communication Skills for Health and Social Care"},null,"Serving Food and Drink",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AG3)-ROW(AG$2)+1>COUNT(AH$2:AH$70),\"\",INDEX(AG:AG,SMALL(AH$2:AH$70,1+ROW(AG3)-ROW(AG$2))))","v":"Serving Food and Drink"},null,"Using Digital Communication Technologies",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AK3)-ROW(AK$2)+1>COUNT(AL$2:AL$70),\"\",INDEX(AK:AK,SMALL(AL$2:AL$70,1+ROW(AK3)-ROW(AK$2))))","v":"Using Digital Communication Technologies"},null,"Caring for and Feeding Animals",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AO3)-ROW(AO$2)+1>COUNT(AP$2:AP$70),\"\",INDEX(AO:AO,SMALL(AP$2:AP$70,1+ROW(AO3)-ROW(AO$2))))","v":"Caring for and Feeding Animals"},null,"Designing Technical Support",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AS3)-ROW(AS$2)+1>COUNT(AT$2:AT$70),\"\",INDEX(AS:AS,SMALL(AT$2:AT$70,1+ROW(AS3)-ROW(AS$2))))","v":"Designing Technical Support"},null,"Taking Part in Fitness Testing",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AW3)-ROW(AW$2)+1>COUNT(AX$2:AX$70),\"\",INDEX(AW:AW,SMALL(AX$2:AX$70,1+ROW(AW3)-ROW(AW$2))))","v":"Taking Part in Fitness Testing"},null,"Training for Fitness",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(BA3)-ROW(BA$2)+1>COUNT(BB$2:BB$70),\"\",INDEX(BA:BA,SMALL(BB$2:BB$70,1+ROW(BA3)-ROW(BA$2))))","v":"Training for Fitness"},null,"Art and Design","Designing a Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF3)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE3)>=3,\"\",ROW()))","v":3},{"$f":"IF(ROW(BF3)-ROW(BF$2)+1>COUNT(BG$2:BG$70),\"\",INDEX(BF:BF,SMALL(BG$2:BG$70,1+ROW(BF3)-ROW(BF$2))))","v":"Designing a Product"}]
["Investigating Variations in Plants and Animals",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A4)>=1,\"\",ROW())","v":4},"Investigating Variations in Plants and Animals",null,"Presenting an Image Using a Camera",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E4)>=1,\"\",ROW())","v":4},"Presenting an Image Using a Camera",null,"Branding a Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I4)>=1,\"\",ROW())","v":4},"Branding a Product",null,"Providing an Activity to Encourage Children to Eat Healthily",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M4)>=1,\"\",ROW())","v":4},"Providing an Activity to Encourage Children to Eat Healthily",null,"Making Carpentry Joints",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q4)>=1,\"\",ROW())","v":4},"Making Carpentry Joints",null,"Producing an Advert",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U4)>=1,\"\",ROW())","v":4},"Producing an Advert",null,"Using a Welding Process to Join Materials",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y4)>=1,\"\",ROW())","v":4},"Using a Welding Process to Join Materials",null,"Making Healthy Snacks When Caring for People",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC4)>=1,\"\",ROW())","v":4},"Making Healthy Snacks When Caring for People",null,"Exploring Local Visitor Attractions",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG4)>=1,\"\",ROW())","v":4},"Exploring Local Visitor Attractions",null,"Solving Technical IT Problems",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK4)>=1,\"\",ROW())","v":4},"Solving Technical IT Problems",null,"Moving and Accommodating Animals",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO4)>=1,\"\",ROW())","v":4},"Moving and Accommodating Animals",null,"Providing Technical Support",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS4)>=1,\"\",ROW())","v":4},"Providing Technical Support",null,"Carrying out Security Searches",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW4)>=1,\"\",ROW())","v":4},"Carrying out Security Searches",null,"Playing Sport",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA4)>=1,\"\",ROW())","v":4},"Playing Sport",null,"Art and Design","Creating a Mood Board",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF4)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE4)>=3,\"\",ROW()))","v":4},"Creating a Mood Board"]
["Measuring Waves Used in Technology",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A5)>=1,\"\",ROW())","v":5},"Measuring Waves Used in Technology",null,"Designing a Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E5)>=1,\"\",ROW())","v":5},"Designing a Product",null,"Creating a Visual Display",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I5)>=1,\"\",ROW())","v":5},"Creating a Visual Display",null,"Providing a Pre-school Children’s Reading Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M5)>=1,\"\",ROW())","v":5},"Providing a Pre-school Children’s Reading Activity",null,"Fixing a Water Pipe",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q5)>=1,\"\",ROW())","v":5},"Fixing a Water Pipe",null,"Layout Design for a Digital Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U5)>=1,\"\",ROW())","v":5},"Layout Design for a Digital Product",null,"Assembling Electronic Circuits",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y5)>=1,\"\",ROW())","v":5},"Assembling Electronic Circuits",null,"Advising Others About Healthy Lifestyles",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC5)>=1,\"\",ROW())","v":5},"Advising Others About Healthy Lifestyles",null,"Exploring Travel and Tourism in the UK",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG5)>=1,\"\",ROW())","v":5},"Exploring Travel and Tourism in the UK",null,"Creating a Spreadsheet to Solve Problems",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK5)>=1,\"\",ROW())","v":5},"Creating a Spreadsheet to Solve Problems",null,"Growing Plants",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO5)>=1,\"\",ROW())","v":5},"Growing Plants",null,"Performing a Dance Routine",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS5)>=1,\"\",ROW())","v":5},"Performing a Dance Routine",null,"Responding to an Incident",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW5)>=1,\"\",ROW())","v":5},"Responding to an Incident",null,"Coaching Skills in Sport",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA5)>=1,\"\",ROW())","v":5},"Coaching Skills in Sport",null,"Art and Design","Creating Prints",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF5)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE5)>=3,\"\",ROW()))","v":5},"Creating Prints"]
["Practical Actions to Protect the Environment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A6)>=1,\"\",ROW())","v":6},"Practical Actions to Protect the Environment",null,"Planning and Marketing an Exhibition",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E6)>=1,\"\",ROW())","v":6},"Planning and Marketing an Exhibition",null,"Presenting a Business Idea",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I6)>=1,\"\",ROW())","v":6},"Presenting a Business Idea",null,"Providing an Activity to Support Children’s Numeracy",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M6)>=1,\"\",ROW())","v":6},{"$f":"IF(ROW(M6)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M6)-ROW(M$2))))","v":"Providing an Activity to Support Children’s Numeracy"},null,"Costing a Small Repair Job",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q6)>=1,\"\",ROW())","v":6},"Costing a Small Repair Job",null,"Creating an Animation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U6)>=1,\"\",ROW())","v":6},"Creating an Animation",null,"Carrying Out Routine Mechanical Servicing of Equipment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y6)>=1,\"\",ROW())","v":6},"Carrying Out Routine Mechanical Servicing of Equipment",null,"Providing a Creative Activity When Caring for People",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC6)>=1,\"\",ROW())","v":6},"Providing a Creative Activity When Caring for People",null,"Contribute to Running a Hospitality and Tourism Event",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG6)>=1,\"\",ROW())","v":6},"Contribute to Running a Hospitality and Tourism Event",null,"Creating a Website",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK6)>=1,\"\",ROW())","v":6},"Creating a Website",null,"Caring for and Keeping Plants Healthy",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO6)>=1,\"\",ROW())","v":6},"Caring for and Keeping Plants Healthy",null,"Performing a Piece of Music",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS6)>=1,\"\",ROW())","v":6},"Performing a Piece of Music",null,"Planning and Navigating a Route",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW6)>=1,\"\",ROW())","v":6},"Planning and Navigating a Route",null,"Assisting in a Sports Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA6)>=1,\"\",ROW())","v":6},"Assisting in a Sports Activity",null,"Applied Science","Carrying Out a Scientific Experiment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF6)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE6)>=3,\"\",ROW()))","v":6},"Carrying Out a Scientific Experiment"]
["Making a Chemical Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A7)>=1,\"\",ROW())","v":7},"Making a Chemical Product",null,"Creating a Mood Board",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E7)>=1,\"\",ROW())","v":7},"Creating a Mood Board",null,"Contributing to Running an Event",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I7)>=1,\"\",ROW())","v":7},"Contributing to Running an Event",null,"Providing a Children’s Creative Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M7)>=1,\"\",ROW())","v":7},"Providing a Children’s Creative Activity",null,"Making Minor Repairs in a House",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q7)>=1,\"\",ROW())","v":7},"Making Minor Repairs in a House",null,"Shooting a Short Film",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U7)>=1,\"\",ROW())","v":7},"Shooting a Short Film",null,"Carrying Out an Electrical Installation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y7)>=1,\"\",ROW())","v":7},"Carrying Out an Electrical Installation",null,"Supporting Others to Use Adapted Equipment Safely",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC7)>=1,\"\",ROW())","v":7},"Supporting Others to Use Adapted Equipment Safely",null,"Delivering Customer Service in Hospitality and Tourism",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG7)>=1,\"\",ROW())","v":7},"Delivering Customer Service in Hospitality and Tourism",null,"Creating a Computer Program",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK7)>=1,\"\",ROW())","v":7},"Creating a Computer Program",null,"Using Workshop Tools in a Land-based Setting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO7)>=1,\"\",ROW())","v":7},"Using Workshop Tools in a Land-based Setting",null,"Acting in a Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS7)>=1,\"\",ROW())","v":7},"Acting in a Performance",null,"Assisting Members of the Public",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW7)>=1,\"\",ROW())","v":7},"Assisting Members of the Public",null,"Contributing to Running a Sports Event",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA7)>=1,\"\",ROW())","v":7},"Contributing to Running a Sports Event",null,"Applied Science","Practical Actions to Protect the Environment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF7)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE7)>=3,\"\",ROW()))","v":7},"Practical Actions to Protect the Environment"]
["Testing the Properties of Products",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A8)>=1,\"\",ROW())","v":8},"Testing the Properties of Products",null,"Creating an Artefact Using Clay",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E8)>=1,\"\",ROW())","v":8},"Creating an Artefact Using Clay",null,"Recording Income and Expenditure",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I8)>=1,\"\",ROW())","v":8},"Recording Income and Expenditure",null,"Providing a Children’s Physical Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M8)>=1,\"\",ROW())","v":8},"Providing a Children’s Physical Activity",null,"Decorating an Inside Wall",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q8)>=1,\"\",ROW())","v":8},"Decorating an Inside Wall",null,"Making an Audio Recording",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U8)>=1,\"\",ROW())","v":8},"Making an Audio Recording",null,"Producing Engineering Drawings Using CAD",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y8)>=1,\"\",ROW())","v":8},"Producing Engineering Drawings Using CAD",null,"Measuring Older Adults’ Fitness Levels for Everyday Tasks",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC8)>=1,\"\",ROW())","v":8},"Measuring Older Adults’ Fitness Levels for Everyday Tasks",null,"Using Websites to Make Holiday Choices",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG8)>=1,\"\",ROW())","v":8},"Using Websites to Make Holiday Choices",null,"Developing a Digital Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK8)>=1,\"\",ROW())","v":8},"Developing a Digital Product",null,"Using Land-based Machinery",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO8)>=1,\"\",ROW())","v":8},"Using Land-based Machinery",null,"Personal Preparation for Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS8)>=1,\"\",ROW())","v":8},"Personal Preparation for Performance",null,"Contributing to your Community",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW8)>=1,\"\",ROW())","v":8},"Contributing to your Community",null,"Getting People Active",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA8)>=1,\"\",ROW())","v":8},"Getting People Active",null,"Applied Science","Making a Chemical Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF8)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE8)>=3,\"\",ROW()))","v":8},"Making a Chemical Product"]
["Investigating Crime Scene Evidence",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,A9)>=1,\"\",ROW())","v":9},"Investigating Crime Scene Evidence",null,"Creating Prints",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,E9)>=1,\"\",ROW())","v":9},"Creating Prints",null,"Communicating with Customers",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,I9)>=1,\"\",ROW())","v":9},"Communicating with Customers",null,"Supporting Children’s Learning Through Everyday Experiences",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,M9)>=1,\"\",ROW())","v":9},"Supporting Children’s Learning Through Everyday Experiences",null,"Making an Electrical Circuit",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Q9)>=1,\"\",ROW())","v":9},"Making an Electrical Circuit",null,"Editing and Sharing a Media Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,U9)>=1,\"\",ROW())","v":9},"Editing and Sharing a Media Product",null,"Carrying Out Routine Service Tasks on a Motor Vehicle",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,Y9)>=1,\"\",ROW())","v":9},"Carrying Out Routine Service Tasks on a Motor Vehicle",null,"Visiting a Health or Social Care Setting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AC9)>=1,\"\",ROW())","v":9},"Visiting a Health or Social Care Setting",null,"Promoting Hospitality and Tourism Events",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AG9)>=1,\"\",ROW())","v":9},"Promoting Hospitality and Tourism Events",null,"Creating a Digital Animated Graphic",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AK9)>=1,\"\",ROW())","v":9},"Creating a Digital Animated Graphic",null,"Preparing Soil for Planting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AO9)>=1,\"\",ROW())","v":9},"Preparing Soil for Planting",null,"Rehearsing for a Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AS9)>=1,\"\",ROW())","v":9},"Rehearsing for a Performance",null,"Taking Part in Sport and Adventurous Activities",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,AW9)>=1,\"\",ROW())","v":9},"Taking Part in Sport and Adventurous Activities",null,"Keeping Active and Healthy",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BA9)>=1,\"\",ROW())","v":9},"Keeping Active and Healthy",null,"Applied Science","Investigating Crime Scene Evidence",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF9)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE9)>=3,\"\",ROW()))","v":9},"Investigating Crime Scene Evidence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Organising a Meeting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF10)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE10)>=3,\"\",ROW()))","v":10},"Organising a Meeting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Branding a Product",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF11)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE11)>=3,\"\",ROW()))","v":11},"Branding a Product"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Presenting a Business Idea",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF12)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE12)>=3,\"\",ROW()))","v":12},"Presenting a Business Idea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Contribute to Running an Event",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF13)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE13)>=3,\"\",ROW()))","v":13},"Contribute to Running an Event"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Recording Income and Expenditure",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF14)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE14)>=3,\"\",ROW()))","v":14},"Recording Income and Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Communicating with Customers",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF15)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE15)>=3,\"\",ROW()))","v":15},"Communicating with Customers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Providing an Activity to Support Children’s Emotional and Social Needs",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF16)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE16)>=3,\"\",ROW()))","v":16},"Providing an Activity to Support Children’s Emotional and Social Needs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Planning a Safe Childcare Environment",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF17)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE17)>=3,\"\",ROW()))","v":17},"Planning a Safe Childcare Environment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Providing a Children’s Creative Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF18)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE18)>=3,\"\",ROW()))","v":18},"Providing a Children’s Creative Activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Supporting Children’s Learning Through Everyday Experiences",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF19)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE19)>=3,\"\",ROW()))","v":19},"Supporting Children’s Learning Through Everyday Experiences"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Drawing a Plan of a Room",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF20)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE20)>=3,\"\",ROW()))","v":20},"Drawing a Plan of a Room"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Building a Simple Wall",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF21)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE21)>=3,\"\",ROW()))","v":21},"Building a Simple Wall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Making Carpentry Joints",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF22)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE22)>=3,\"\",ROW()))","v":22},"Making Carpentry Joints"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Fixing a Water Pipe",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF23)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE23)>=3,\"\",ROW()))","v":23},"Fixing a Water Pipe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Making an Electrical Circuit",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF24)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE24)>=3,\"\",ROW()))","v":24},"Making an Electrical Circuit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Creating a Storyboard",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF25)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE25)>=3,\"\",ROW()))","v":25},"Creating a Storyboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Designing an Interactive Presentation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF26)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE26)>=3,\"\",ROW()))","v":26},"Designing an Interactive Presentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Creating an Animation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF27)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE27)>=3,\"\",ROW()))","v":27},"Creating an Animation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Shooting a Short Film",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF28)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE28)>=3,\"\",ROW()))","v":28},"Shooting a Short Film"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Manufacturing an Engineered Product Using Hand Tools",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF29)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE29)>=3,\"\",ROW()))","v":29},"Manufacturing an Engineered Product Using Hand Tools"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Carrying out Electrical Installation",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF30)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE30)>=3,\"\",ROW()))","v":30},"Carrying out Electrical Installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Producing Engineering Drawings using CAD",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF31)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE31)>=3,\"\",ROW()))","v":31},"Producing Engineering Drawings using CAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Carrying Out Routine Service Tasks on a Motor Vehicle",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF32)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE32)>=3,\"\",ROW()))","v":32},"Carrying Out Routine Service Tasks on a Motor Vehicle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Communication Skills for Health and Social Care",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF33)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE33)>=3,\"\",ROW()))","v":33},"Communication Skills for Health and Social Care"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Making Healthy Snacks When Caring for People",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF34)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE34)>=3,\"\",ROW()))","v":34},"Making Healthy Snacks When Caring for People"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Advising Others About Healthy Lifestyles",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF35)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE35)>=3,\"\",ROW()))","v":35},"Advising Others About Healthy Lifestyles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Measuring Older Adults’ Fitness Levels for Everyday Tasks",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF36)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE36)>=3,\"\",ROW()))","v":36},"Measuring Older Adults’ Fitness Levels for Everyday Tasks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Preparing and Cooking Food",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF37)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE37)>=3,\"\",ROW()))","v":37},"Preparing and Cooking Food"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Serving Food and Drink",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF38)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE38)>=3,\"\",ROW()))","v":38},"Serving Food and Drink"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Exploring Local Visitor Attractions",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF39)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE39)>=3,\"\",ROW()))","v":39},"Exploring Local Visitor Attractions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Exploring Travel and Tourism in the UK",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF40)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE40)>=3,\"\",ROW()))","v":40},"Exploring Travel and Tourism in the UK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Delivering Customer Service in Hospitality and Tourism",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF41)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE41)>=3,\"\",ROW()))","v":41},"Delivering Customer Service in Hospitality and Tourism"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Developing Digital Information Using IT",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF42)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE42)>=3,\"\",ROW()))","v":42},"Developing Digital Information Using IT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Using Digital Communication Technologies",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF43)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE43)>=3,\"\",ROW()))","v":43},"Using Digital Communication Technologies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Creating a Spreadsheet to Solve Problems",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF44)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE44)>=3,\"\",ROW()))","v":44},"Creating a Spreadsheet to Solve Problems"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Creating a Website",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF45)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE45)>=3,\"\",ROW()))","v":45},"Creating a Website"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Caring for and Feeding Animals",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF46)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE46)>=3,\"\",ROW()))","v":46},"Caring for and Feeding Animals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Moving and Accommodating Animals",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF47)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE47)>=3,\"\",ROW()))","v":47},"Moving and Accommodating Animals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Growing Plants",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF48)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE48)>=3,\"\",ROW()))","v":48},"Growing Plants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Preparing Soil for Planting",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF49)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE49)>=3,\"\",ROW()))","v":49},"Preparing Soil for Planting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Using a Stimulus for Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF50)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE50)>=3,\"\",ROW()))","v":50},"Using a Stimulus for Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Performing a Dance Routine",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF51)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE51)>=3,\"\",ROW()))","v":51},"Performing a Dance Routine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Performing a Piece of Music",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF52)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE52)>=3,\"\",ROW()))","v":52},"Performing a Piece of Music"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Acting in a Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF53)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE53)>=3,\"\",ROW()))","v":53},"Acting in a Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Rehearsing for a Performance",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF54)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE54)>=3,\"\",ROW()))","v":54},"Rehearsing for a Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Taking Part in Fitness Testing",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF55)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE55)>=3,\"\",ROW()))","v":55},"Taking Part in Fitness Testing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Responding to an Incident",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF56)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE56)>=3,\"\",ROW()))","v":56},"Responding to an Incident"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Planning and Navigating a Route",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF57)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE57)>=3,\"\",ROW()))","v":57},"Planning and Navigating a Route"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Contributing to your Community",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF58)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE58)>=3,\"\",ROW()))","v":58},"Contributing to your Community"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Playing Sport",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF59)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE59)>=3,\"\",ROW()))","v":59},"Playing Sport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Assisting in a Sports Activity",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF60)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE60)>=3,\"\",ROW()))","v":60},"Assisting in a Sports Activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Getting People Active",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF61)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE61)>=3,\"\",ROW()))","v":61},"Getting People Active"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Keeping Active and Healthy",{"$f":"IF(COUNTIF(Diploma!$E$14:$E$77,BF62)>=1,\"\",IF(COUNTIF(Diploma!$F$14:$F$77,BE62)>=3,\"\",ROW()))","v":62},"Keeping Active and Healthy"]

{"sheet":"Cert Data Sheet","index":11,"n_rows":175,"n_cols":11,"rows_kept":175,"cut":false,"hidden":true,"merged":[]}
["Core units A",null,null,null,null,null,null,"Optional Units"]
["Sector","Unit number","Unit Name","GLH",null,null,null,"Sector","Unit Number","Unit Name","GLH"]
["Applied Science","A1","Being Organised",30,null,"Applied Science","Testing the Quality of Products","Applied Science","ASc5","Testing the Quality of Products",40]
["Applied Science","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Carrying Out a Scientific Experiment","Applied Science","ASc6","Carrying Out a Scientific Experiment",40]
["Art and Design","A1","Being Organised",30,null,"Applied Science","Investigating Variations in Plants and Animals","Applied Science","ASc7","Investigating Variations in Plants and Animals",40]
["Art and Design","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Measuring Waves Used in Technology","Applied Science","ASc8","Measuring Waves Used in Technology",40]
["Business","A1","Being Organised",30,null,"Applied Science","Practical Actions to Protect the Environment","Applied Science","ASc9","Practical Actions to Protect the Environment",40]
["Business","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Making a Chemical Product","Applied Science","ASc10","Making a Chemical Product",40]
["Caring for Children","A1","Being Organised",30,null,"Applied Science","Testing the Properties of Products","Applied Science","ASc11","Testing the Properties of Products",40]
["Caring for Children","A2","Developing a Personal Progression Plan",30,null,"Applied Science","Investigating Crime Scene Evidence","Applied Science","ASc12","Investigating Crime Scene Evidence",40]
["Construction","A1","Being Organised",30,null,"Art and Design","Creating an Art Image","Art and Design","AD5","Creating an Art Image",40]
["Construction","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Creating a 3D Art Object","Art and Design","AD6","Creating a 3D Art Object",40]
["Digital Media","A1","Being Organised",30,null,"Art and Design","Presenting an Image Using a Camera","Art and Design","AD7","Presenting an Image Using a Camera",40]
["Digital Media","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Designing a Product","Art and Design","AD8","Designing a Product",40]
["Engineering","A1","Being Organised",30,null,"Art and Design","Planning and Marketing an Exhibition","Art and Design","AD9","Planning and Marketing an Exhibition",40]
["Engineering","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Creating a Mood Board","Art and Design","AD10","Creating a Mood Board",40]
["Health and Social Care","A1","Being Organised",30,null,"Art and Design","Creating an Artefact Using Clay","Art and Design","AD11","Creating an Artefact Using Clay",40]
["Health and Social Care","A2","Developing a Personal Progression Plan",30,null,"Art and Design","Creating Prints","Art and Design","AD12","Creating Prints",40]
["Hospitality and Tourism","A1","Being Organised",30,null,"Business","Finding Out About Businesses in Your Area","Business","B5","Finding Out About Businesses in Your Area",40]
["Hospitality and Tourism","A2","Developing a Personal Progression Plan",30,null,"Business","Organising a Meeting","Business","B6","Organising a Meeting",40]
["Information Technology","A1","Being Organised",30,null,"Business","Branding a Product","Business","B7","Branding a Product",40]
["Information Technology","A2","Developing a Personal Progression Plan",30,null,"Business","Creating a Visual Display","Business","B8","Creating a Visual Display",40]
["Land based Studies","A1","Being Organised",30,null,"Business","Presenting a Business Idea","Business","B9","Presenting a Business Idea",40]
["Land based Studies","A2","Developing a Personal Progression Plan",30,null,"Business","Contributing to Running an Event","Business","B10","Contributing to Running an Event",40]
["Performing Arts","A1","Being Organised",30,null,"Business","Recording Income and Expenditure","Business","B11","Recording Income and Expenditure",40]
["Performing Arts","A2","Developing a Personal Progression Plan",30,null,"Business","Communicating with Customers","Business","B12","Communicating with Customers",40]
["Public Services","A1","Being Organised",30,null,"Caring for Children","Providing an Activity to Support Children’s Emotional and Social Needs","Caring for Children","CfC5","Providing an Activity to Support Children’s Emotional and Social Needs",40]
["Public Services","A2","Developing a Personal Progression Plan",30,null,"Caring for Children","Planning a Safe Childcare Environment","Caring for Children","CfC6","Planning a Safe Childcare Environment",40]
["Sport","A1","Being Organised",30,null,"Caring for Children","Providing an Activity to Encourage Children to Eat Healthily","Caring for Children","CfC7","Providing an Activity to Encourage Children to Eat Healthily",40]
["Sport","A2","Developing a Personal Progression Plan",30,null,"Caring for Children","Providing a Pre-school Children’s Reading Activity","Caring for Children","CfC8","Providing a Pre-school Children’s Reading Activity",40]
["Vocational Studies","A1","Being Organised",30,null,"Caring for Children","Providing an Activity to Support Children’s Numeracy","Caring for Children","CfC9","Providing an Activity to Support Children’s Numeracy",40]
["Vocational Studies","A2","Developing a Personal Progression Plan",30,null,"Caring for Children","Providing a Children’s Creative Activity","Caring for Children","CfC10","Providing a Children’s Creative Activity",40]
[null,null,null,null,null,"Caring for Children","Providing a Children’s Physical Activity","Caring for Children","CfC11","Providing a Children’s Physical Activity",40]
[null,null,null,null,null,"Caring for Children","Supporting Children’s Learning Through Everyday Experiences","Caring for Children","CfC12","Supporting Children’s Learning Through Everyday Experiences",40]
[null,null,null,null,null,"Construction","Drawing a Plan of a Room","Construction","CON5","Drawing a Plan of a Room",40]
[null,null,null,null,null,"Construction","Building a Simple Wall","Construction","CON6","Building a Simple Wall",40]
[null,null,null,null,null,"Construction","Making Carpentry Joints","Construction","CON7","Making Carpentry Joints",40]
[null,null,null,null,null,"Construction","Fixing a Water Pipe","Construction","CON8","Fixing a Water Pipe",40]
[null,null,null,null,null,"Construction","Costing a Small Repair Job","Construction","CON9","Costing a Small Repair Job",40]
[null,null,null,null,null,"Construction","Making Minor Repairs in a House","Construction","CON10","Making Minor Repairs in a House",40]
[null,null,null,null,null,"Construction","Decorating an Inside Wall","Construction","CON11","Decorating an Inside Wall",40]
[null,null,null,null,null,"Construction","Making an Electrical Circuit","Construction","CON12","Making an Electrical Circuit",40]
[null,null,null,null,null,"Digital Media","Creating a Storyboard","Digital Media","DM5","Creating a Storyboard",40]
[null,null,null,null,null,"Digital Media","Designing an Interactive Presentation","Digital Media","DM6","Designing an Interactive Presentation",40]
[null,null,null,null,null,"Digital Media","Producing an Advert","Digital Media","DM7","Producing an Advert",40]
[null,null,null,null,null,"Digital Media","Layout Design for a Digital Product","Digital Media","DM8","Layout Design for a Digital Product",40]
[null,null,null,null,null,"Digital Media","Creating an Animation","Digital Media","DM9","Creating an Animation",40]
[null,null,null,null,null,"Digital Media","Shooting a Short Film","Digital Media","DM10","Shooting a Short Film",40]
[null,null,null,null,null,"Digital Media","Making an Audio Recording","Digital Media","DM11","Making an Audio Recording",40]
[null,null,null,null,null,"Digital Media","Editing and Sharing a Media Product","Digital Media","DM12","Editing and Sharing a Media Product",40]
[null,null,null,null,null,"Engineering","Manufacturing an Engineered Product Using Hand Tools","Engineering","ENG5","Manufacturing an Engineered Product Using Hand Tools",40]
[null,null,null,null,null,"Engineering","Manufacturing a Component Using Machining Processes","Engineering","ENG6","Manufacturing a Component Using Machining Processes",40]
[null,null,null,null,null,"Engineering","Using a Welding Process to Join Materials","Engineering","ENG7","Using a Welding Process to Join Materials",40]
[null,null,null,null,null,"Engineering","Assembling Electronic Circuits","Engineering","ENG8","Assembling Electronic Circuits",40]
[null,null,null,null,null,"Engineering","Carrying Out Routine Mechanical Servicing of Equipment","Engineering","ENG9","Carrying Out Routine Mechanical Servicing of Equipment",40]
[null,null,null,null,null,"Engineering","Carrying Out an Electrical Installation","Engineering","ENG10","Carrying Out an Electrical Installation",40]
[null,null,null,null,null,"Engineering","Producing Engineering Drawings Using CAD","Engineering","ENG11","Producing Engineering Drawings Using CAD",40]
[null,null,null,null,null,"Engineering","Carrying Out Routine Service Tasks on a Motor Vehicle","Engineering","ENG12","Carrying Out Routine Service Tasks on a Motor Vehicle",40]
[null,null,null,null,null,"Health and Social Care","Finding Out About Health and Social Care Services","Health and Social Care","HSC5","Finding Out About Health and Social Care Services",40]
[null,null,null,null,null,"Health and Social Care","Communication Skills for Health and Social Care","Health and Social Care","HSC6","Communication Skills for Health and Social Care",40]
[null,null,null,null,null,"Health and Social Care","Making Healthy Snacks When Caring for People","Health and Social Care","HSC7","Making Healthy Snacks When Caring for People",40]
[null,null,null,null,null,"Health and Social Care","Advising Others About Healthy Lifestyles","Health and Social Care","HSC8","Advising Others About Healthy Lifestyles",40]
[null,null,null,null,null,"Health and Social Care","Providing a Creative Activity When Caring for People","Health and Social Care","HSC9","Providing a Creative Activity When Caring for People",40]
[null,null,null,null,null,"Health and Social Care","Supporting Others to Use Adapted Equipment Safely","Health and Social Care","HSC10","Supporting Others to Use Adapted Equipment Safely",40]
[null,null,null,null,null,"Health and Social Care","Measuring Older Adults’ Fitness Levels for Everyday Tasks","Health and Social Care","HSC11","Measuring Older Adults’ Fitness Levels for Everyday Tasks",40]
[null,null,null,null,null,"Health and Social Care","Visiting a Health or Social Care Setting","Health and Social Care","HSC12","Visiting a Health or Social Care Setting",40]
[null,null,null,null,null,"Hospitality and Tourism","Preparing and Cooking Food","Hospitality and Tourism","HT5","Preparing and Cooking Food",40]
[null,null,null,null,null,"Hospitality and Tourism","Serving Food and Drink","Hospitality and Tourism","HT6","Serving Food and Drink",40]
[null,null,null,null,null,"Hospitality and Tourism","Exploring Local Visitor Attractions","Hospitality and Tourism","HT7","Exploring Local Visitor Attractions",40]
[null,null,null,null,null,"Hospitality and Tourism","Exploring Travel and Tourism in the UK","Hospitality and Tourism","HT8","Exploring Travel and Tourism in the UK",40]
[null,null,null,null,null,"Hospitality and Tourism","Contribute to Running a Hospitality and Tourism Event","Hospitality and Tourism","HT9","Contribute to Running a Hospitality and Tourism Event",40]
[null,null,null,null,null,"Hospitality and Tourism","Delivering Customer Service in Hospitality and Tourism","Hospitality and Tourism","HT10","Delivering Customer Service in Hospitality and Tourism",40]
[null,null,null,null,null,"Hospitality and Tourism","Using Websites to Make Holiday Choices","Hospitality and Tourism","HT11","Using Websites to Make Holiday Choices",40]
[null,null,null,null,null,"Hospitality and Tourism","Promoting Hospitality and Tourism Events","Hospitality and Tourism","HT12","Promoting Hospitality and Tourism Events",40]
[null,null,null,null,null,"Information Technology","Developing Digital Information Using IT","Information Technology","IT5","Developing Digital Information Using IT",40]
[null,null,null,null,null,"Information Technology","Using Digital Communication Technologies","Information Technology","IT6","Using Digital Communication Technologies",40]
[null,null,null,null,null,"Information Technology","Solving Technical IT Problems","Information Technology","IT7","Solving Technical IT Problems",40]
[null,null,null,null,null,"Information Technology","Creating a Spreadsheet to Solve Problems","Information Technology","IT8","Creating a Spreadsheet to Solve Problems",40]
[null,null,null,null,null,"Information Technology","Creating a Website","Information Technology","IT9","Creating a Website",40]
[null,null,null,null,null,"Information Technology","Creating a Computer Program","Information Technology","IT10","Creating a Computer Program",40]
[null,null,null,null,null,"Information Technology","Developing a Digital Product","Information Technology","IT11","Developing a Digital Product",40]
[null,null,null,null,null,"Information Technology","Creating a Digital Animated Graphic","Information Technology","IT12","Creating a Digital Animated Graphic",40]
[null,null,null,null,null,"Land based Studies","Finding Out About the Land-based Sector","Land based Studies","LBS5","Finding Out About the Land-based Sector",40]
[null,null,null,null,null,"Land based Studies","Caring for and Feeding Animals","Land based Studies","LBS6","Caring for and Feeding Animals",40]
[null,null,null,null,null,"Land based Studies","Moving and Accommodating Animals","Land based Studies","LBS7","Moving and Accommodating Animals",40]
[null,null,null,null,null,"Land based Studies","Growing Plants","Land based Studies","LBS8","Growing Plants",40]
[null,null,null,null,null,"Land based Studies","Caring for and Keeping Plants Healthy","Land based Studies","LBS9","Caring for and Keeping Plants Healthy",40]
[null,null,null,null,null,"Land based Studies","Using Workshop Tools in a Land-based Setting","Land based Studies","LBS10","Using Workshop Tools in a Land-based Setting",40]
[null,null,null,null,null,"Land based Studies","Using Land-based Machinery","Land based Studies","LBS11","Using Land-based Machinery",40]
[null,null,null,null,null,"Land based Studies","Preparing Soil for Planting","Land based Studies","LBS12","Preparing Soil for Planting",40]
[null,null,null,null,null,"Performing Arts","Using a Stimulus for Performance","Performing Arts","PA5","Using a Stimulus for Performance",40]
[null,null,null,null,null,"Performing Arts","Designing Technical Support","Performing Arts","PA6","Designing Technical Support",40]
[null,null,null,null,null,"Performing Arts","Providing Technical Support","Performing Arts","PA7","Providing Technical Support",40]
[null,null,null,null,null,"Performing Arts","Performing a Dance Routine","Performing Arts","PA8","Performing a Dance Routine",40]
[null,null,null,null,null,"Performing Arts","Performing a Piece of Music","Performing Arts","PA9","Performing a Piece of Music",40]
[null,null,null,null,null,"Performing Arts","Acting in a Performance","Performing Arts","PA10","Acting in a Performance",40]
[null,null,null,null,null,"Performing Arts","Personal Preparation for Performance","Performing Arts","PA11","Personal Preparation for Performance",40]
[null,null,null,null,null,"Performing Arts","Rehearsing for a Performance","Performing Arts","PA12","Rehearsing for a Performance",40]
[null,null,null,null,null,"Public Services","Finding Out about Public Services","Public Services","PS5","Finding Out about Public Services",40]
[null,null,null,null,null,"Public Services","Taking Part in Fitness Testing","Public Services","PS6","Taking Part in Fitness Testing",40]
[null,null,null,null,null,"Public Services","Carrying out Security Searches","Public Services","PS7","Carrying out Security Searches",40]
[null,null,null,null,null,"Public Services","Responding to an Incident","Public Services","PS8","Responding to an Incident",40]
[null,null,null,null,null,"Public Services","Planning and Navigating a Route","Public Services","PS9","Planning and Navigating a Route",40]
[null,null,null,null,null,"Public Services","Assisting Members of the Public","Public Services","PS10","Assisting Members of the Public",40]
[null,null,null,null,null,"Public Services","Contributing to your Community","Public Services","PS11","Contributing to your Community",40]
[null,null,null,null,null,"Public Services","Taking Part in Sport and Adventurous Activities","Public Services","PS12","Taking Part in Sport and Adventurous Activities",40]
[null,null,null,null,null,"Sport","How Exercise Affects the Body","Sport","SP5","How Exercise Affects the Body",40]
[null,null,null,null,null,"Sport","Training for Fitness","Sport","SP6","Training for Fitness",40]
[null,null,null,null,null,"Sport","Playing Sport","Sport","SP7","Playing Sport",40]
[null,null,null,null,null,"Sport","Coaching Skills in Sport","Sport","SP8","Coaching Skills in Sport",40]
[null,null,null,null,null,"Sport","Assisting in a Sports Activity","Sport","SP9","Assisting in a Sports Activity",40]
[null,null,null,null,null,"Sport","Contributing to Running a Sports Event","Sport","SP10","Contributing to Running a Sports Event",40]
[null,null,null,null,null,"Sport","Getting People Active","Sport","SP11","Getting People Active",40]
[null,null,null,null,null,"Sport","Keeping Active and Healthy","Sport","SP12","Keeping Active and Healthy",40]
[null,null,null,null,null,"Vocational Studies","Creating an Art Image","Art and Design","AD5","Creating an Art Image",40]
[null,null,null,null,null,"Vocational Studies","Designing a Product","Art and Design","AD8","Designing a Product",40]
[null,null,null,null,null,"Vocational Studies","Creating a Mood Board","Art and Design","AD10","Creating a Mood Board",40]
[null,null,null,null,null,"Vocational Studies","Creating Prints","Art and Design","AD12","Creating Prints",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out a Scientific Experiment","Applied Science","ASc6","Carrying Out a Scientific Experiment",40]
[null,null,null,null,null,"Vocational Studies","Practical Actions to Protect the Environment","Applied Science","ASc9","Practical Actions to Protect the Environment",40]
[null,null,null,null,null,"Vocational Studies","Making a Chemical Product","Applied Science","ASc10","Making a Chemical Product",40]
[null,null,null,null,null,"Vocational Studies","Investigating Crime Scene Evidence","Applied Science","ASc12","Investigating Crime Scene Evidence",40]
[null,null,null,null,null,"Vocational Studies","Organising a Meeting","Business","B6","Organising a Meeting",40]
[null,null,null,null,null,"Vocational Studies","Branding a Product","Business","B7","Branding a Product",40]
[null,null,null,null,null,"Vocational Studies","Presenting a Business Idea","Business","B9","Presenting a Business Idea",40]
[null,null,null,null,null,"Vocational Studies","Contribute to Running an Event","Business","B10","Contribute to Running an Event",40]
[null,null,null,null,null,"Vocational Studies","Recording Income and Expenditure","Business","B11","Recording Income and Expenditure",40]
[null,null,null,null,null,"Vocational Studies","Communicating with Customers","Business","B12","Communicating with Customers",40]
[null,null,null,null,null,"Vocational Studies","Providing an Activity to Support Children’s Emotional and Social Needs","Caring for Children","CfC5","Providing an Activity to Support Children’s Emotional and Social Needs",40]
[null,null,null,null,null,"Vocational Studies","Planning a Safe Childcare Environment","Caring for Children","CfC6","Planning a Safe Childcare Environment",40]
[null,null,null,null,null,"Vocational Studies","Providing a Children’s Creative Activity","Caring for Children","CfC10","Providing a Children’s Creative Activity",40]
[null,null,null,null,null,"Vocational Studies","Supporting Children’s Learning Through Everyday Experiences","Caring for Children","CfC12","Supporting Children’s Learning Through Everyday Experiences",40]
[null,null,null,null,null,"Vocational Studies","Drawing a Plan of a Room","Construction","CON5","Drawing a Plan of a Room",40]
[null,null,null,null,null,"Vocational Studies","Building a Simple Wall","Construction","CON6","Building a Simple Wall",40]
[null,null,null,null,null,"Vocational Studies","Making Carpentry Joints","Construction","CON7","Making Carpentry Joints",40]
[null,null,null,null,null,"Vocational Studies","Fixing a Water Pipe","Construction","CON8","Fixing a Water Pipe",40]
[null,null,null,null,null,"Vocational Studies","Making an Electrical Circuit","Construction","CON12","Making an Electrical Circuit",40]
[null,null,null,null,null,"Vocational Studies","Creating a Storyboard","Digital Media","DM5","Creating a Storyboard",40]
[null,null,null,null,null,"Vocational Studies","Designing an Interactive Presentation","Digital Media","DM6","Designing an Interactive Presentation",40]
[null,null,null,null,null,"Vocational Studies","Creating an Animation","Digital Media","DM9","Creating an Animation",40]
[null,null,null,null,null,"Vocational Studies","Shooting a Short Film","Digital Media","DM10","Shooting a Short Film",40]
[null,null,null,null,null,"Vocational Studies","Manufacturing an Engineered Product Using Hand Tools","Engineering","ENG5","Manufacturing an Engineered Product Using Hand Tools",40]
[null,null,null,null,null,"Vocational Studies","Carrying out Electrical Installation","Engineering","ENG10","Carrying out Electrical Installation",40]
[null,null,null,null,null,"Vocational Studies","Producing Engineering Drawings using CAD","Engineering","ENG11","Producing Engineering Drawings using CAD",40]
[null,null,null,null,null,"Vocational Studies","Carrying Out Routine Service Tasks on a Motor Vehicle","Engineering","ENG12","Carrying Out Routine Service Tasks on a Motor Vehicle",40]
[null,null,null,null,null,"Vocational Studies","Communication Skills for Health and Social Care","Health and Social Care","HSC6","Communication Skills for Health and Social Care",40]
[null,null,null,null,null,"Vocational Studies","Making Healthy Snacks When Caring for People","Health and Social Care","HSC7","Making Healthy Snacks When Caring for People",40]
[null,null,null,null,null,"Vocational Studies","Advising Others About Healthy Lifestyles","Health and Social Care","HSC8","Advising Others About Healthy Lifestyles",40]
[null,null,null,null,null,"Vocational Studies","Measuring Older Adults’ Fitness Levels for Everyday Tasks","Health and Social Care","HSC11","Measuring Older Adults’ Fitness Levels for Everyday Tasks",40]
[null,null,null,null,null,"Vocational Studies","Preparing and Cooking Food","Hospitality","HT5","Preparing and Cooking Food",40]
[null,null,null,null,null,"Vocational Studies","Serving Food and Drink","Hospitality","HT6","Serving Food and Drink",40]
[null,null,null,null,null,"Vocational Studies","Exploring Local Visitor Attractions","Hospitality","HT7","Exploring Local Visitor Attractions",40]
[null,null,null,null,null,"Vocational Studies","Exploring Travel and Tourism in the UK","Hospitality","HT8","Exploring Travel and Tourism in the UK",40]
[null,null,null,null,null,"Vocational Studies","Delivering Customer Service in Hospitality and Tourism","Hospitality","HT10","Delivering Customer Service in Hospitality and Tourism",40]
[null,null,null,null,null,"Vocational Studies","Developing Digital Information Using IT","IT","IT5","Developing Digital Information Using IT",40]
[null,null,null,null,null,"Vocational Studies","Using Digital Communication Technologies","IT","IT6","Using Digital Communication Technologies",40]
[null,null,null,null,null,"Vocational Studies","Creating a Spreadsheet to Solve Problems","IT","IT8","Creating a Spreadsheet to Solve Problems",40]
[null,null,null,null,null,"Vocational Studies","Creating a Website","IT","IT9","Creating a Website",40]
[null,null,null,null,null,"Vocational Studies","Caring for and Feeding Animals","Land-based Studies","LBS6","Caring for and Feeding Animals",40]
[null,null,null,null,null,"Vocational Studies","Moving and Accommodating Animals","Land-based Studies","LBS7","Moving and Accommodating Animals",40]
[null,null,null,null,null,"Vocational Studies","Growing Plants","Land-based Studies","LBS8","Growing Plants",40]
[null,null,null,null,null,"Vocational Studies","Preparing Soil for Planting","Land-based Studies","LBS12","Preparing Soil for Planting",40]
[null,null,null,null,null,"Vocational Studies","Using a Stimulus for Performance","Performing Arts","PA5","Using a Stimulus for Performance",40]
[null,null,null,null,null,"Vocational Studies","Performing a Dance Routine","Performing Arts","PA8","Performing a Dance Routine",40]
[null,null,null,null,null,"Vocational Studies","Performing a Piece of Music","Performing Arts","PA9","Performing a Piece of Music",40]
[null,null,null,null,null,"Vocational Studies","Acting in a Performance","Performing Arts","PA10","Acting in a Performance",40]
[null,null,null,null,null,"Vocational Studies","Rehearsing for a Performance","Performing Arts","PA12","Rehearsing for a Performance",40]
[null,null,null,null,null,"Vocational Studies","Taking Part in Fitness Testing","Public Services","PS6","Taking Part in Fitness Testing",40]
[null,null,null,null,null,"Vocational Studies","Responding to an Incident","Public Services","PS8","Responding to an Incident",40]
[null,null,null,null,null,"Vocational Studies","Planning and Navigating a Route","Public Services","PS9","Planning and Navigating a Route",40]
[null,null,null,null,null,"Vocational Studies","Contributing to your Community","Public Services","PS11","Contributing to your Community",40]
[null,null,null,null,null,"Vocational Studies","Playing Sport","Sport","SP7","Playing Sport",40]
[null,null,null,null,null,"Vocational Studies","Assisting in a Sports Activity","Sport","SP9","Assisting in a Sports Activity",40]
[null,null,null,null,null,"Vocational Studies","Getting People Active","Sport","SP11","Getting People Active",40]
[null,null,null,null,null,"Vocational Studies","Keeping Active and Healthy","Sport","SP12","Keeping Active and Healthy",40]

{"sheet":"Cert Dropdown","index":12,"n_rows":62,"n_cols":60,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Applied Science Group A",null,null,null,"Art and Design Group A",null,null,null,"Business Group A",null,null,null,"Caring for Children Group A",null,null,null,"Construction Group A",null,null,null,"Digital Media Group A",null,null,null,"Engineering Group A",null,null,null,"Health and Social Care Group A",null,null,null,"Hospitality and Tourism Group A",null,null,null,"Information Terchnology Group A",null,null,null,"Land-based Studies Group A",null,null,null,"Performing Arts Group A",null,null,null,"Public Services Group A",null,null,null,"Sport Group A",null,null,null,null,"Vocational Studies Group A"]
["Testing the Quality of Products",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(A2)-ROW(A$2)+1>COUNT(B$2:B$70),\"\",INDEX(A:A,SMALL(B$2:B$70,1+ROW(A2)-ROW(A$2))))","v":"Testing the Quality of Products"},null,"Creating an Art Image",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(E2)-ROW(E$2)+1>COUNT(F$2:F$70),\"\",INDEX(E:E,SMALL(F$2:F$70,1+ROW(E2)-ROW(E$2))))","v":"Creating an Art Image"},null,"Finding Out About Businesses in Your Area",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(I2)-ROW(I$2)+1>COUNT(J$2:J$70),\"\",INDEX(I:I,SMALL(J$2:J$70,1+ROW(I2)-ROW(I$2))))","v":"Finding Out About Businesses in Your Area"},null,"Providing an Activity to Support Children’s Emotional and Social Needs",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(M2)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M2)-ROW(M$2))))","v":"Providing an Activity to Support Children’s Emotional and Social Needs"},null,"Drawing a Plan of a Room",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(Q2)-ROW(Q$2)+1>COUNT(R$2:R$70),\"\",INDEX(Q:Q,SMALL(R$2:R$70,1+ROW(Q2)-ROW(Q$2))))","v":"Drawing a Plan of a Room"},null,"Creating a Storyboard",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(U2)-ROW(U$2)+1>COUNT(V$2:V$70),\"\",INDEX(U:U,SMALL(V$2:V$70,1+ROW(U2)-ROW(U$2))))","v":"Creating a Storyboard"},null,"Manufacturing an Engineered Product Using Hand Tools",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(Y2)-ROW(Y$2)+1>COUNT(Z$2:Z$70),\"\",INDEX(Y:Y,SMALL(Z$2:Z$70,1+ROW(Y2)-ROW(Y$2))))","v":"Manufacturing an Engineered Product Using Hand Tools"},null,"Finding Out About Health and Social Care Services",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AC2)-ROW(AC$2)+1>COUNT(AD$2:AD$70),\"\",INDEX(AC:AC,SMALL(AD$2:AD$70,1+ROW(AC2)-ROW(AC$2))))","v":"Finding Out About Health and Social Care Services"},null,"Preparing and Cooking Food",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AG2)-ROW(AG$2)+1>COUNT(AH$2:AH$70),\"\",INDEX(AG:AG,SMALL(AH$2:AH$70,1+ROW(AG2)-ROW(AG$2))))","v":"Preparing and Cooking Food"},null,"Developing Digital Information Using IT",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AK2)-ROW(AK$2)+1>COUNT(AL$2:AL$70),\"\",INDEX(AK:AK,SMALL(AL$2:AL$70,1+ROW(AK2)-ROW(AK$2))))","v":"Developing Digital Information Using IT"},null,"Finding Out About the Land-based Sector",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AO2)-ROW(AO$2)+1>COUNT(AP$2:AP$70),\"\",INDEX(AO:AO,SMALL(AP$2:AP$70,1+ROW(AO2)-ROW(AO$2))))","v":"Finding Out About the Land-based Sector"},null,"Using a Stimulus for Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AS2)-ROW(AS$2)+1>COUNT(AT$2:AT$70),\"\",INDEX(AS:AS,SMALL(AT$2:AT$70,1+ROW(AS2)-ROW(AS$2))))","v":"Using a Stimulus for Performance"},null,"Finding Out about Public Services",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(AW2)-ROW(AW$2)+1>COUNT(AX$2:AX$70),\"\",INDEX(AW:AW,SMALL(AX$2:AX$70,1+ROW(AW2)-ROW(AW$2))))","v":"Finding Out about Public Services"},null,"How Exercise Affects the Body",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(BA2)-ROW(BA$2)+1>COUNT(BB$2:BB$70),\"\",INDEX(BA:BA,SMALL(BB$2:BB$70,1+ROW(BA2)-ROW(BA$2))))","v":"How Exercise Affects the Body"},null,"Art and Design","Creating an Art Image",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF2)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE2)>=1,\"\",ROW()))","v":2},{"$f":"IF(ROW(BF2)-ROW(BF$2)+1>COUNT(BG$2:BG$70),\"\",INDEX(BF:BF,SMALL(BG$2:BG$70,1+ROW(BF2)-ROW(BF$2))))","v":"Creating an Art Image"}]
["Carrying Out a Scientific Experiment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(A3)-ROW(A$2)+1>COUNT(B$2:B$70),\"\",INDEX(A:A,SMALL(B$2:B$70,1+ROW(A3)-ROW(A$2))))","v":"Carrying Out a Scientific Experiment"},null,"Creating a 3D Art Object",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(E3)-ROW(E$2)+1>COUNT(F$2:F$70),\"\",INDEX(E:E,SMALL(F$2:F$70,1+ROW(E3)-ROW(E$2))))","v":"Creating a 3D Art Object"},null,"Organising a Meeting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(I3)-ROW(I$2)+1>COUNT(J$2:J$70),\"\",INDEX(I:I,SMALL(J$2:J$70,1+ROW(I3)-ROW(I$2))))","v":"Organising a Meeting"},null,"Planning a Safe Childcare Environment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(M3)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M3)-ROW(M$2))))","v":"Planning a Safe Childcare Environment"},null,"Building a Simple Wall",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(Q3)-ROW(Q$2)+1>COUNT(R$2:R$70),\"\",INDEX(Q:Q,SMALL(R$2:R$70,1+ROW(Q3)-ROW(Q$2))))","v":"Building a Simple Wall"},null,"Designing an Interactive Presentation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(U3)-ROW(U$2)+1>COUNT(V$2:V$70),\"\",INDEX(U:U,SMALL(V$2:V$70,1+ROW(U3)-ROW(U$2))))","v":"Designing an Interactive Presentation"},null,"Manufacturing a Component Using Machining Processes",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(Y3)-ROW(Y$2)+1>COUNT(Z$2:Z$70),\"\",INDEX(Y:Y,SMALL(Z$2:Z$70,1+ROW(Y3)-ROW(Y$2))))","v":"Manufacturing a Component Using Machining Processes"},null,"Communication Skills for Health and Social Care",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AC3)-ROW(AC$2)+1>COUNT(AD$2:AD$70),\"\",INDEX(AC:AC,SMALL(AD$2:AD$70,1+ROW(AC3)-ROW(AC$2))))","v":"Communication Skills for Health and Social Care"},null,"Serving Food and Drink",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AG3)-ROW(AG$2)+1>COUNT(AH$2:AH$70),\"\",INDEX(AG:AG,SMALL(AH$2:AH$70,1+ROW(AG3)-ROW(AG$2))))","v":"Serving Food and Drink"},null,"Using Digital Communication Technologies",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AK3)-ROW(AK$2)+1>COUNT(AL$2:AL$70),\"\",INDEX(AK:AK,SMALL(AL$2:AL$70,1+ROW(AK3)-ROW(AK$2))))","v":"Using Digital Communication Technologies"},null,"Caring for and Feeding Animals",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AO3)-ROW(AO$2)+1>COUNT(AP$2:AP$70),\"\",INDEX(AO:AO,SMALL(AP$2:AP$70,1+ROW(AO3)-ROW(AO$2))))","v":"Caring for and Feeding Animals"},null,"Designing Technical Support",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AS3)-ROW(AS$2)+1>COUNT(AT$2:AT$70),\"\",INDEX(AS:AS,SMALL(AT$2:AT$70,1+ROW(AS3)-ROW(AS$2))))","v":"Designing Technical Support"},null,"Taking Part in Fitness Testing",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(AW3)-ROW(AW$2)+1>COUNT(AX$2:AX$70),\"\",INDEX(AW:AW,SMALL(AX$2:AX$70,1+ROW(AW3)-ROW(AW$2))))","v":"Taking Part in Fitness Testing"},null,"Training for Fitness",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA3)>=1,\"\",ROW())","v":3},{"$f":"IF(ROW(BA3)-ROW(BA$2)+1>COUNT(BB$2:BB$70),\"\",INDEX(BA:BA,SMALL(BB$2:BB$70,1+ROW(BA3)-ROW(BA$2))))","v":"Training for Fitness"},null,"Art and Design","Designing a Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF3)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE3)>=1,\"\",ROW()))","v":3},{"$f":"IF(ROW(BF3)-ROW(BF$2)+1>COUNT(BG$2:BG$70),\"\",INDEX(BF:BF,SMALL(BG$2:BG$70,1+ROW(BF3)-ROW(BF$2))))","v":"Designing a Product"}]
["Investigating Variations in Plants and Animals",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A4)>=1,\"\",ROW())","v":4},"Investigating Variations in Plants and Animals",null,"Presenting an Image Using a Camera",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E4)>=1,\"\",ROW())","v":4},"Presenting an Image Using a Camera",null,"Branding a Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I4)>=1,\"\",ROW())","v":4},"Branding a Product",null,"Providing an Activity to Encourage Children to Eat Healthily",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M4)>=1,\"\",ROW())","v":4},"Providing an Activity to Encourage Children to Eat Healthily",null,"Making Carpentry Joints",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q4)>=1,\"\",ROW())","v":4},"Making Carpentry Joints",null,"Producing an Advert",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U4)>=1,\"\",ROW())","v":4},"Producing an Advert",null,"Using a Welding Process to Join Materials",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y4)>=1,\"\",ROW())","v":4},"Using a Welding Process to Join Materials",null,"Making Healthy Snacks When Caring for People",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC4)>=1,\"\",ROW())","v":4},"Making Healthy Snacks When Caring for People",null,"Exploring Local Visitor Attractions",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG4)>=1,\"\",ROW())","v":4},"Exploring Local Visitor Attractions",null,"Solving Technical IT Problems",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK4)>=1,\"\",ROW())","v":4},"Solving Technical IT Problems",null,"Moving and Accommodating Animals",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO4)>=1,\"\",ROW())","v":4},"Moving and Accommodating Animals",null,"Providing Technical Support",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS4)>=1,\"\",ROW())","v":4},"Providing Technical Support",null,"Carrying out Security Searches",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW4)>=1,\"\",ROW())","v":4},"Carrying out Security Searches",null,"Playing Sport",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA4)>=1,\"\",ROW())","v":4},"Playing Sport",null,"Art and Design","Creating a Mood Board",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF4)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE4)>=1,\"\",ROW()))","v":4},"Creating a Mood Board"]
["Measuring Waves Used in Technology",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A5)>=1,\"\",ROW())","v":5},"Measuring Waves Used in Technology",null,"Designing a Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E5)>=1,\"\",ROW())","v":5},"Designing a Product",null,"Creating a Visual Display",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I5)>=1,\"\",ROW())","v":5},"Creating a Visual Display",null,"Providing a Pre-school Children’s Reading Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M5)>=1,\"\",ROW())","v":5},"Providing a Pre-school Children’s Reading Activity",null,"Fixing a Water Pipe",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q5)>=1,\"\",ROW())","v":5},"Fixing a Water Pipe",null,"Layout Design for a Digital Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U5)>=1,\"\",ROW())","v":5},"Layout Design for a Digital Product",null,"Assembling Electronic Circuits",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y5)>=1,\"\",ROW())","v":5},"Assembling Electronic Circuits",null,"Advising Others About Healthy Lifestyles",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC5)>=1,\"\",ROW())","v":5},"Advising Others About Healthy Lifestyles",null,"Exploring Travel and Tourism in the UK",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG5)>=1,\"\",ROW())","v":5},"Exploring Travel and Tourism in the UK",null,"Creating a Spreadsheet to Solve Problems",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK5)>=1,\"\",ROW())","v":5},"Creating a Spreadsheet to Solve Problems",null,"Growing Plants",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO5)>=1,\"\",ROW())","v":5},"Growing Plants",null,"Performing a Dance Routine",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS5)>=1,\"\",ROW())","v":5},"Performing a Dance Routine",null,"Responding to an Incident",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW5)>=1,\"\",ROW())","v":5},"Responding to an Incident",null,"Coaching Skills in Sport",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA5)>=1,\"\",ROW())","v":5},"Coaching Skills in Sport",null,"Art and Design","Creating Prints",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF5)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE5)>=1,\"\",ROW()))","v":5},"Creating Prints"]
["Practical Actions to Protect the Environment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A6)>=1,\"\",ROW())","v":6},"Practical Actions to Protect the Environment",null,"Planning and Marketing an Exhibition",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E6)>=1,\"\",ROW())","v":6},"Planning and Marketing an Exhibition",null,"Presenting a Business Idea",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I6)>=1,\"\",ROW())","v":6},"Presenting a Business Idea",null,"Providing an Activity to Support Children’s Numeracy",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M6)>=1,\"\",ROW())","v":6},{"$f":"IF(ROW(M6)-ROW(M$2)+1>COUNT(N$2:N$70),\"\",INDEX(M:M,SMALL(N$2:N$70,1+ROW(M6)-ROW(M$2))))","v":"Providing an Activity to Support Children’s Numeracy"},null,"Costing a Small Repair Job",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q6)>=1,\"\",ROW())","v":6},"Costing a Small Repair Job",null,"Creating an Animation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U6)>=1,\"\",ROW())","v":6},"Creating an Animation",null,"Carrying Out Routine Mechanical Servicing of Equipment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y6)>=1,\"\",ROW())","v":6},"Carrying Out Routine Mechanical Servicing of Equipment",null,"Providing a Creative Activity When Caring for People",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC6)>=1,\"\",ROW())","v":6},"Providing a Creative Activity When Caring for People",null,"Contribute to Running a Hospitality and Tourism Event",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG6)>=1,\"\",ROW())","v":6},"Contribute to Running a Hospitality and Tourism Event",null,"Creating a Website",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK6)>=1,\"\",ROW())","v":6},"Creating a Website",null,"Caring for and Keeping Plants Healthy",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO6)>=1,\"\",ROW())","v":6},"Caring for and Keeping Plants Healthy",null,"Performing a Piece of Music",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS6)>=1,\"\",ROW())","v":6},"Performing a Piece of Music",null,"Planning and Navigating a Route",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW6)>=1,\"\",ROW())","v":6},"Planning and Navigating a Route",null,"Assisting in a Sports Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA6)>=1,\"\",ROW())","v":6},"Assisting in a Sports Activity",null,"Applied Science","Carrying Out a Scientific Experiment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF6)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE6)>=1,\"\",ROW()))","v":6},"Carrying Out a Scientific Experiment"]
["Making a Chemical Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A7)>=1,\"\",ROW())","v":7},"Making a Chemical Product",null,"Creating a Mood Board",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E7)>=1,\"\",ROW())","v":7},"Creating a Mood Board",null,"Contributing to Running an Event",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I7)>=1,\"\",ROW())","v":7},"Contributing to Running an Event",null,"Providing a Children’s Creative Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M7)>=1,\"\",ROW())","v":7},"Providing a Children’s Creative Activity",null,"Making Minor Repairs in a House",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q7)>=1,\"\",ROW())","v":7},"Making Minor Repairs in a House",null,"Shooting a Short Film",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U7)>=1,\"\",ROW())","v":7},"Shooting a Short Film",null,"Carrying Out an Electrical Installation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y7)>=1,\"\",ROW())","v":7},"Carrying Out an Electrical Installation",null,"Supporting Others to Use Adapted Equipment Safely",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC7)>=1,\"\",ROW())","v":7},"Supporting Others to Use Adapted Equipment Safely",null,"Delivering Customer Service in Hospitality and Tourism",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG7)>=1,\"\",ROW())","v":7},"Delivering Customer Service in Hospitality and Tourism",null,"Creating a Computer Program",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK7)>=1,\"\",ROW())","v":7},"Creating a Computer Program",null,"Using Workshop Tools in a Land-based Setting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO7)>=1,\"\",ROW())","v":7},"Using Workshop Tools in a Land-based Setting",null,"Acting in a Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS7)>=1,\"\",ROW())","v":7},"Acting in a Performance",null,"Assisting Members of the Public",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW7)>=1,\"\",ROW())","v":7},"Assisting Members of the Public",null,"Contributing to Running a Sports Event",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA7)>=1,\"\",ROW())","v":7},"Contributing to Running a Sports Event",null,"Applied Science","Practical Actions to Protect the Environment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF7)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE7)>=1,\"\",ROW()))","v":7},"Practical Actions to Protect the Environment"]
["Testing the Properties of Products",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A8)>=1,\"\",ROW())","v":8},"Testing the Properties of Products",null,"Creating an Artefact Using Clay",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E8)>=1,\"\",ROW())","v":8},"Creating an Artefact Using Clay",null,"Recording Income and Expenditure",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I8)>=1,\"\",ROW())","v":8},"Recording Income and Expenditure",null,"Providing a Children’s Physical Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M8)>=1,\"\",ROW())","v":8},"Providing a Children’s Physical Activity",null,"Decorating an Inside Wall",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q8)>=1,\"\",ROW())","v":8},"Decorating an Inside Wall",null,"Making an Audio Recording",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U8)>=1,\"\",ROW())","v":8},"Making an Audio Recording",null,"Producing Engineering Drawings Using CAD",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y8)>=1,\"\",ROW())","v":8},"Producing Engineering Drawings Using CAD",null,"Measuring Older Adults’ Fitness Levels for Everyday Tasks",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC8)>=1,\"\",ROW())","v":8},"Measuring Older Adults’ Fitness Levels for Everyday Tasks",null,"Using Websites to Make Holiday Choices",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG8)>=1,\"\",ROW())","v":8},"Using Websites to Make Holiday Choices",null,"Developing a Digital Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK8)>=1,\"\",ROW())","v":8},"Developing a Digital Product",null,"Using Land-based Machinery",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO8)>=1,\"\",ROW())","v":8},"Using Land-based Machinery",null,"Personal Preparation for Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS8)>=1,\"\",ROW())","v":8},"Personal Preparation for Performance",null,"Contributing to your Community",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW8)>=1,\"\",ROW())","v":8},"Contributing to your Community",null,"Getting People Active",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA8)>=1,\"\",ROW())","v":8},"Getting People Active",null,"Applied Science","Making a Chemical Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF8)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE8)>=1,\"\",ROW()))","v":8},"Making a Chemical Product"]
["Investigating Crime Scene Evidence",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,A9)>=1,\"\",ROW())","v":9},"Investigating Crime Scene Evidence",null,"Creating Prints",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,E9)>=1,\"\",ROW())","v":9},"Creating Prints",null,"Communicating with Customers",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,I9)>=1,\"\",ROW())","v":9},"Communicating with Customers",null,"Supporting Children’s Learning Through Everyday Experiences",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,M9)>=1,\"\",ROW())","v":9},"Supporting Children’s Learning Through Everyday Experiences",null,"Making an Electrical Circuit",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Q9)>=1,\"\",ROW())","v":9},"Making an Electrical Circuit",null,"Editing and Sharing a Media Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,U9)>=1,\"\",ROW())","v":9},"Editing and Sharing a Media Product",null,"Carrying Out Routine Service Tasks on a Motor Vehicle",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,Y9)>=1,\"\",ROW())","v":9},"Carrying Out Routine Service Tasks on a Motor Vehicle",null,"Visiting a Health or Social Care Setting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AC9)>=1,\"\",ROW())","v":9},"Visiting a Health or Social Care Setting",null,"Promoting Hospitality and Tourism Events",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AG9)>=1,\"\",ROW())","v":9},"Promoting Hospitality and Tourism Events",null,"Creating a Digital Animated Graphic",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AK9)>=1,\"\",ROW())","v":9},"Creating a Digital Animated Graphic",null,"Preparing Soil for Planting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AO9)>=1,\"\",ROW())","v":9},"Preparing Soil for Planting",null,"Rehearsing for a Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AS9)>=1,\"\",ROW())","v":9},"Rehearsing for a Performance",null,"Taking Part in Sport and Adventurous Activities",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,AW9)>=1,\"\",ROW())","v":9},"Taking Part in Sport and Adventurous Activities",null,"Keeping Active and Healthy",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BA9)>=1,\"\",ROW())","v":9},"Keeping Active and Healthy",null,"Applied Science","Investigating Crime Scene Evidence",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF9)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE9)>=1,\"\",ROW()))","v":9},"Investigating Crime Scene Evidence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Organising a Meeting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF10)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE10)>=1,\"\",ROW()))","v":10},"Organising a Meeting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Branding a Product",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF11)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE11)>=1,\"\",ROW()))","v":11},"Branding a Product"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Presenting a Business Idea",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF12)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE12)>=1,\"\",ROW()))","v":12},"Presenting a Business Idea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Contribute to Running an Event",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF13)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE13)>=1,\"\",ROW()))","v":13},"Contribute to Running an Event"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Recording Income and Expenditure",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF14)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE14)>=1,\"\",ROW()))","v":14},"Recording Income and Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business","Communicating with Customers",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF15)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE15)>=1,\"\",ROW()))","v":15},"Communicating with Customers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Providing an Activity to Support Children’s Emotional and Social Needs",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF16)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE16)>=1,\"\",ROW()))","v":16},"Providing an Activity to Support Children’s Emotional and Social Needs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Planning a Safe Childcare Environment",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF17)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE17)>=1,\"\",ROW()))","v":17},"Planning a Safe Childcare Environment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Providing a Children’s Creative Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF18)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE18)>=1,\"\",ROW()))","v":18},"Providing a Children’s Creative Activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caring for Children","Supporting Children’s Learning Through Everyday Experiences",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF19)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE19)>=1,\"\",ROW()))","v":19},"Supporting Children’s Learning Through Everyday Experiences"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Drawing a Plan of a Room",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF20)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE20)>=1,\"\",ROW()))","v":20},"Drawing a Plan of a Room"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Building a Simple Wall",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF21)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE21)>=1,\"\",ROW()))","v":21},"Building a Simple Wall"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Making Carpentry Joints",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF22)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE22)>=1,\"\",ROW()))","v":22},"Making Carpentry Joints"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Fixing a Water Pipe",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF23)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE23)>=1,\"\",ROW()))","v":23},"Fixing a Water Pipe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction","Making an Electrical Circuit",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF24)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE24)>=1,\"\",ROW()))","v":24},"Making an Electrical Circuit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Creating a Storyboard",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF25)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE25)>=1,\"\",ROW()))","v":25},"Creating a Storyboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Designing an Interactive Presentation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF26)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE26)>=1,\"\",ROW()))","v":26},"Designing an Interactive Presentation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Creating an Animation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF27)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE27)>=1,\"\",ROW()))","v":27},"Creating an Animation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital Media","Shooting a Short Film",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF28)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE28)>=1,\"\",ROW()))","v":28},"Shooting a Short Film"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Manufacturing an Engineered Product Using Hand Tools",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF29)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE29)>=1,\"\",ROW()))","v":29},"Manufacturing an Engineered Product Using Hand Tools"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Carrying out Electrical Installation",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF30)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE30)>=1,\"\",ROW()))","v":30},"Carrying out Electrical Installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Producing Engineering Drawings using CAD",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF31)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE31)>=1,\"\",ROW()))","v":31},"Producing Engineering Drawings using CAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering","Carrying Out Routine Service Tasks on a Motor Vehicle",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF32)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE32)>=1,\"\",ROW()))","v":32},"Carrying Out Routine Service Tasks on a Motor Vehicle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Communication Skills for Health and Social Care",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF33)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE33)>=1,\"\",ROW()))","v":33},"Communication Skills for Health and Social Care"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Making Healthy Snacks When Caring for People",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF34)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE34)>=1,\"\",ROW()))","v":34},"Making Healthy Snacks When Caring for People"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Advising Others About Healthy Lifestyles",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF35)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE35)>=1,\"\",ROW()))","v":35},"Advising Others About Healthy Lifestyles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health and Social Care","Measuring Older Adults’ Fitness Levels for Everyday Tasks",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF36)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE36)>=1,\"\",ROW()))","v":36},"Measuring Older Adults’ Fitness Levels for Everyday Tasks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Preparing and Cooking Food",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF37)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE37)>=1,\"\",ROW()))","v":37},"Preparing and Cooking Food"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Serving Food and Drink",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF38)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE38)>=1,\"\",ROW()))","v":38},"Serving Food and Drink"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Exploring Local Visitor Attractions",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF39)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE39)>=1,\"\",ROW()))","v":39},"Exploring Local Visitor Attractions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Exploring Travel and Tourism in the UK",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF40)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE40)>=1,\"\",ROW()))","v":40},"Exploring Travel and Tourism in the UK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospitality","Delivering Customer Service in Hospitality and Tourism",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF41)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE41)>=1,\"\",ROW()))","v":41},"Delivering Customer Service in Hospitality and Tourism"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Developing Digital Information Using IT",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF42)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE42)>=1,\"\",ROW()))","v":42},"Developing Digital Information Using IT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Using Digital Communication Technologies",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF43)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE43)>=1,\"\",ROW()))","v":43},"Using Digital Communication Technologies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Creating a Spreadsheet to Solve Problems",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF44)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE44)>=1,\"\",ROW()))","v":44},"Creating a Spreadsheet to Solve Problems"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT","Creating a Website",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF45)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE45)>=1,\"\",ROW()))","v":45},"Creating a Website"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Caring for and Feeding Animals",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF46)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE46)>=1,\"\",ROW()))","v":46},"Caring for and Feeding Animals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Moving and Accommodating Animals",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF47)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE47)>=1,\"\",ROW()))","v":47},"Moving and Accommodating Animals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Growing Plants",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF48)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE48)>=1,\"\",ROW()))","v":48},"Growing Plants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land-based Studies","Preparing Soil for Planting",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF49)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE49)>=1,\"\",ROW()))","v":49},"Preparing Soil for Planting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Using a Stimulus for Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF50)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE50)>=1,\"\",ROW()))","v":50},"Using a Stimulus for Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Performing a Dance Routine",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF51)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE51)>=1,\"\",ROW()))","v":51},"Performing a Dance Routine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Performing a Piece of Music",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF52)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE52)>=1,\"\",ROW()))","v":52},"Performing a Piece of Music"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Acting in a Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF53)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE53)>=1,\"\",ROW()))","v":53},"Acting in a Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts","Rehearsing for a Performance",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF54)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE54)>=1,\"\",ROW()))","v":54},"Rehearsing for a Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Taking Part in Fitness Testing",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF55)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE55)>=1,\"\",ROW()))","v":55},"Taking Part in Fitness Testing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Responding to an Incident",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF56)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE56)>=1,\"\",ROW()))","v":56},"Responding to an Incident"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Planning and Navigating a Route",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF57)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE57)>=1,\"\",ROW()))","v":57},"Planning and Navigating a Route"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Services","Contributing to your Community",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF58)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE58)>=1,\"\",ROW()))","v":58},"Contributing to your Community"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Playing Sport",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF59)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE59)>=1,\"\",ROW()))","v":59},"Playing Sport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Assisting in a Sports Activity",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF60)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE60)>=1,\"\",ROW()))","v":60},"Assisting in a Sports Activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Getting People Active",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF61)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE61)>=1,\"\",ROW()))","v":61},"Getting People Active"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport","Keeping Active and Healthy",{"$f":"IF(COUNTIF(Certificate!$E$12:$E$72,BF62)>=1,\"\",IF(COUNTIF(Certificate!$F$12:$F$72,BE62)>=1,\"\",ROW()))","v":62},"Keeping Active and Healthy"]